/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 vote354 views1 answer
Sql join on a subquery
SQL
17 votes361 views4 answers
Postgres list users
SQL
0 vote364 views1 answer
Alter domain sql
SQL
2 votes351 views1 answer
Guid to string sql
SQL
8 votes362 views2 answers
Alert table name mysql
SQL
2 votes330 views1 answer
How to search table name in stored procedure in sql server
SQL
6 votes346 views2 answers
Join vs union
SQL
0 vote322 views1 answer
Access refused mysql xampp server
SQL
0 vote346 views1 answer
Mysql disable query caching
SQL
0 vote292 views1 answer
Oracle sql developer script output limit
SQL

Share