/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

-2 votes167 views1 answer
No module named '_sqlite3
SQL
0 vote149 views1 answer
How to get n result in sql
SQL
1 vote150 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote186 views1 answer
Increase date by one day in sql oracle
SQL
0 vote176 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote182 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
1 vote342 views1 answer
Postgres upgrade to superuser
SQL
2 votes234 views1 answer
Oracle list grants on package
SQL
1 vote151 views1 answer
Oracle sql listagg
SQL
0 vote152 views1 answer
Oracle list subpartitions
SQL

Share