/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

0 vote233 views1 answer
Mysql get date diff in months
SQL
7 votes258 views2 answers
Phpmyadmin change password
SQL
3 votes231 views2 answers
How to load files in mysql
SQL
16 votes246 views3 answers
Update table from another table
SQL
0 vote224 views1 answer
Install ms sql server management studio
SQL
0 vote224 views1 answer
Postgres enumerated type
SQL
0 vote236 views2 answers
Jsonb
SQL
1 vote227 views1 answer
Alphabetical order mysql
SQL
0 vote237 views1 answer
Get the Db column names from a SqlDataReader
SQL
6 votes233 views5 answers
Sql add months to date
SQL

Share