/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 vote148 views1 answer
Enable mysql slow query log
SQL
14 votes191 views2 answers
Oracle add column with default value
SQL
1 vote146 views1 answer
Python escape string for sql
SQL
1 vote177 views1 answer
Oracle rolling back
SQL
0 vote187 views1 answer
Cast as decimal postgresql
SQL
1 vote245 views1 answer
Psql search table
SQL
0 vote208 views1 answer
Mysql cast null to string
SQL
0 vote191 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote184 views1 answer
Mysql search multiple tables
SQL
1 vote173 views1 answer
Select from one table where not on the other
SQL

Share