/SQL/Average salary in sql

Average salary in sql

Average salary in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

0

Find below average salary in sql

SELECT first_name, salary 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

1 vote257 views2 answers
Reset mysqli fetch_arra
SQL
0 vote273 views1 answer
Mysql update set sum
SQL
0 vote279 views1 answer
How to login to mysql in homestead
SQL
0 vote264 views1 answer
RowDataPacket
SQL
21 votes268 views3 answers
Average sql
SQL
0 vote261 views1 answer
Price-colour
SQL
1 vote271 views1 answer
Mysql query bulk insert
SQL
14 votes289 views3 answers
Inner join sql oracle
SQL
1 vote267 views1 answer
Postgresql last element of array
SQL
0 vote290 views1 answer
SQL Server date literal
SQL

Share