/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

11 votes408 views2 answers
Import mysql dump command line windows
SQL
1 vote368 views1 answer
Print year of a date sql
SQL
1 vote327 views1 answer
Foreign key constraint in ms sql
SQL
0 vote396 views1 answer
Acutal month year
SQL
3 votes365 views2 answers
Find the median in sql
SQL
38 votes454 views6 answers
Ubuntu install mysql client
SQL
0 vote304 views1 answer
'0000-00-00' for column '
SQL
1 vote344 views1 answer
Load sql into mamp
SQL
0 vote391 views1 answer
T-sql delete view if exists
SQL
0 vote349 views1 answer
Sql contains vs like
SQL

Share