/SQL/Find below average salary in sql

Find below average salary in sql

Find below average salary in sql

SELECT first_name, salary FROM employees
WHERE salary <= (SELECT AVG(salary) FROM employees);

0

FIND AVERAGE SALARY EARNER IN SQL

SELECT FIRST_NAME 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 vote125 views1 answer
Sql server get date of previous sunday
SQL
3 votes99 views2 answers
Coalesce mysql
SQL
0 vote139 views1 answer
Interview experience as a call?
SQL
1 vote165 views1 answer
Apex run 404
SQL
2 votes139 views1 answer
Mysql select default if null
SQL
1 vote130 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote137 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
1 vote151 views1 answer
Sql list all procedures
SQL
0 vote122 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
-1 vote121 views2 answers
Sql convert date to string yyyy-mm-dd
SQL

Share