/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

13 votes374 views2 answers
Get date from now() mysql
SQL
1 vote349 views1 answer
Table infromation in sql server
SQL
1 vote377 views2 answers
Oracle list service names
SQL
0 vote357 views1 answer
Mysql 8 error on identified by
SQL
3 votes339 views1 answer
Oracle function
SQL
0 vote340 views1 answer
Mysql set boolean default value
SQL
0 vote357 views2 answers
How to get the date from datetime in mysql
SQL
3 votes332 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote359 views1 answer
Add many column to sap iq table
SQL
0 vote330 views1 answer
If null don't update
SQL

Share