/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

1 vote140 views2 answers
Sql server backup table
SQL
0 vote154 views1 answer
Mysql 8 error on identified by
SQL
4 votes145 views6 answers
Sql select statement
SQL
-1 vote144 views1 answer
Mysql #1064 error
SQL
0 vote215 views1 answer
How to get number of months between 2 dates sql server
SQL
1 vote95 views1 answer
Insert into sql
SQL
0 vote160 views1 answer
Except in sql alchemy
SQL
0 vote167 views1 answer
How convert into in in sql query
SQL
21 votes149 views5 answers
Oracle all tables
SQL
1 vote146 views1 answer
Mysql view command
SQL

Share