/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 vote259 views1 answer
T-SQL Never ending DELETE
SQL
14 votes263 views3 answers
Trim sql
SQL
8 votes257 views1 answer
Check mysql version phpmyadmin
SQL
0 vote249 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
17 votes264 views4 answers
Sort by mysql
SQL
0 vote317 views1 answer
Oracle convert int to date
SQL
1 vote271 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote267 views2 answers
How to prevent sql injection in java
SQL
0 vote289 views1 answer
Alternative for LIMIT sql
SQL
1 vote253 views1 answer
Oracle avg
SQL

Share