/SQL/Average salary in sql

Average salary in sql

Average salary in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

0

Find below average salary in sql

SELECT first_name, salary FROM employees
WHERE salary <= (SELECT AVG(salary) FROM employees);

0

FIND ABOVE AVERAGE SALARY EARNER IN SQL

SELECT FIRST_NAME, LAST_NAME
FROM EMPLOYEES
WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);

0

Similar codes

3 votes138 views2 answers
Java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
SQL
0 vote167 views1 answer
Replace sqlalchemy
SQL
0 vote137 views1 answer
Mysqldump ignore table
SQL
0 vote138 views6 answers
Unique key in sql
SQL
1 vote147 views1 answer
Postgresql transaction discard all
SQL
0 vote192 views1 answer
Sql developer format sql
SQL
0 vote154 views1 answer
Oracle last connexion
SQL
0 vote124 views1 answer
Duplicate foreign key constraint name
SQL
0 vote183 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote181 views1 answer
Sql multiple into
SQL

Share