/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

24 votes154 views5 answers
Sql reset auto increment
SQL
1 vote164 views2 answers
Reset mysqli fetch_arra
SQL
10 votes291 views4 answers
Mysql if else
SQL
0 vote155 views1 answer
Power bi find all ids not in other tables
SQL
0 vote227 views1 answer
Oracle db get table sizes
SQL
15 votes154 views5 answers
If null mysql
SQL
4 votes165 views1 answer
T-sql get duplicate rows
SQL
6 votes181 views2 answers
How to get yesterday date in mysql
SQL
0 vote176 views1 answer
Sql last time database was accessed
SQL
0 vote158 views1 answer
How to insert multiple rows in mysql using laravel
SQL

Share