/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 vote239 views1 answer
Oracle show grants on table
SQL
0 vote242 views2 answers
Mysql decimal remove trailing zeros
SQL
-1 vote247 views1 answer
Spring boot mysql connection properties
SQL
1 vote238 views1 answer
Events mysql
SQL
3 votes216 views1 answer
Get all elements sql
SQL
5 votes226 views3 answers
Mysql update field from one table to another
SQL
0 vote235 views1 answer
Soql user profile
SQL
2 votes232 views1 answer
SQL column name Postgre
SQL
0 vote262 views1 answer
Wp_query raw sql
SQL
1 vote258 views3 answers
Mysql on delete set null
SQL

Share