/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 vote227 views1 answer
Primary key multiple
SQL
0 vote198 views1 answer
Oracle job schedules
SQL
2 votes243 views1 answer
Tcl in sql
SQL
0 vote200 views1 answer
Mysql count grouped rows
SQL
0 vote200 views1 answer
Bigquery declare
SQL
0 vote219 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote213 views1 answer
Alter database name script
SQL
0 vote213 views1 answer
Mysql sum per week
SQL
2 votes199 views1 answer
Codeigniter print last sql query
SQL
0 vote192 views1 answer
Get created time of database psql 8
SQL

Share