/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 vote266 views2 answers
Sql multiline comment
SQL
15 votes283 views6 answers
Laravel db transaction
SQL
0 vote247 views1 answer
Mysql group rows with same value
SQL
0 vote304 views1 answer
Creating sqeuence in oracle database
SQL
0 vote314 views3 answers
Mysql CAST(amount as float)
SQL
6 votes246 views1 answer
Sqlite foreign key
SQL
12 votes263 views4 answers
Mysql version
SQL
3 votes322 views1 answer
Oracle list invalid password logon denied
SQL
0 vote276 views1 answer
Postgres get database encoding
SQL
1 vote250 views1 answer
Sql only five first row
SQL

Share