/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

1 vote106 views10 answers
Stack overflow
SQL
0 vote114 views1 answer
Get who is hired in month in sql
SQL
1 vote128 views3 answers
Getdate function in postgresql
SQL
5 votes109 views4 answers
Select random rows sql
SQL
0 vote121 views1 answer
Mysql backup certain tables workbench
SQL
0 vote110 views1 answer
Mysql to get column name in database
SQL
1 vote119 views1 answer
Postgres convert exisiting column to text
SQL
1 vote124 views2 answers
Find nth highest salary of an employee
SQL
1 vote110 views1 answer
Sql server 2012 query history
SQL
1 vote123 views1 answer
Postgresql not in
SQL

Share