/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 vote191 views2 answers
Procedure syntax
SQL
0 vote173 views1 answer
Php mysqli install
SQL
2 votes163 views1 answer
Oracle cpu per session
SQL
8 votes174 views2 answers
Replace string value in sql
SQL
0 vote206 views1 answer
Sql remove decimal places
SQL
2 votes179 views1 answer
Oracle index size
SQL
0 vote151 views0 answer
SQL
0 vote175 views3 answers
Group_concat sql server
SQL
19 votes197 views6 answers
Create table sqlite
SQL
0 vote185 views1 answer
Shell script to log mysql cpu usage
SQL

Share