/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

4 votes193 views2 answers
Truncate oracle
SQL
0 vote186 views1 answer
Except in sql
SQL
4 votes172 views1 answer
Sql quote in string
SQL
0 vote181 views1 answer
Not between mysql
SQL
0 vote195 views1 answer
Offset in postgresql example
SQL
1 vote191 views1 answer
Pl sql ptint
SQL
0 vote181 views1 answer
Sql cheetsheet
SQL
0 vote172 views3 answers
Insert or ignore postgres
SQL
4 votes167 views2 answers
What is table in sql
SQL
0 vote230 views1 answer
Sql query for login with email or username
SQL

Share