/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 vote369 views1 answer
Sql random sampling per group
SQL
10 votes310 views1 answer
Query to find object dependencies in oracle
SQL
0 vote325 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote307 views1 answer
Mysql wsrep ls
SQL
21 votes324 views1 answer
Cheatsheet for sql
SQL
5 votes291 views1 answer
Sql first day of current year
SQL
0 vote324 views1 answer
Alter table engine mysql
SQL
34 votes311 views6 answers
Sql change data type
SQL
12 votes349 views1 answer
Run mysql instance in docker
SQL
1 vote333 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL

Share