/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 vote148 views1 answer
Sql server size of every table in a db
SQL
14 votes136 views3 answers
Delete all records from table except sql
SQL
0 vote150 views1 answer
Get the next column of a table in mysql
SQL
0 vote141 views1 answer
Downgrading sql localdb visual studio
SQL
3 votes143 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote172 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote153 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
-1 vote156 views1 answer
Module operator in oracle sql
SQL
0 vote163 views1 answer
How to retrive the today date sql
SQL
0 vote168 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL

Share