/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

8 votes343 views2 answers
Sqlsrv default port
SQL
18 votes337 views3 answers
Find column name in database
SQL
1 vote329 views1 answer
Show indices in mysql table
SQL
0 vote322 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote349 views1 answer
C# get sql min date
SQL
13 votes357 views3 answers
Insert mysql ifile nto database
SQL
0 vote474 views1 answer
ORA-01400
SQL
0 vote322 views2 answers
Drop check constraint in ms sql
SQL
3 votes319 views1 answer
Oracle undo tablespace list by user
SQL
1 vote338 views1 answer
Sql server epoch to datetime
SQL

Share