/SQL/Find below average salary in sql

Find below average salary in sql

Find below average salary in sql

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

0

FIND AVERAGE SALARY EARNER IN SQL

SELECT FIRST_NAME 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

0 vote111 views1 answer
Mysql reset wp_options
SQL
12 votes102 views2 answers
Select into insert sql server
SQL
0 vote111 views1 answer
T sql check active deadlock
SQL
2 votes110 views1 answer
Oracle convert run_duration to number
SQL
1 vote103 views2 answers
Mysql spring boot application.properties
SQL
1 vote122 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
5 votes112 views1 answer
Commentaire table oracle
SQL
1 vote106 views1 answer
Default
SQL
1 vote64 views1 answer
Mysql show attributes of a table
SQL
5 votes101 views1 answer
Oracle ORA-00054 origin
SQL

Share