/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 vote145 views1 answer
Postgres meta command to show all rows in table
SQL
22 votes148 views6 answers
Create sql table
SQL
10 votes130 views4 answers
Join with multiple conditions sql
SQL
1 vote134 views1 answer
Trigger in postgresql to change incoming entry
SQL
1 vote147 views1 answer
How to select multiple columns from different tables in mysql
SQL
1 vote145 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote140 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote153 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote266 views2 answers
Postgres select from last 3 months
SQL
-2 votes147 views2 answers
Add auto_increment column to existing table mysql
SQL

Share