/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 vote220 views1 answer
SQL Server Enterprise
SQL
0 vote298 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote228 views1 answer
Raiserror with nowait
SQL
3 votes212 views2 answers
Oracle synonym
SQL
8 votes227 views2 answers
Sqlsrv default port
SQL
0 vote227 views1 answer
Mysql last friday of current month
SQL
21 votes225 views6 answers
Change column in mysql
SQL
1 vote206 views1 answer
Select from one table where not on the other
SQL
3 votes303 views1 answer
Oracle cannot access v$session
SQL
5 votes215 views1 answer
Mysql created at yesterdau
SQL

Share