/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 vote173 views2 answers
Identity column in sql server
SQL
2 votes191 views3 answers
Mysql kill
SQL
1 vote132 views1 answer
Full text index mysql
SQL
0 vote169 views1 answer
Connect to ssms with python
SQL
8 votes128 views2 answers
Alter column name in mssql
SQL
0 vote163 views1 answer
Sql select rows between 1000 and 2000
SQL
1 vote182 views1 answer
Continue in sql
SQL
0 vote163 views1 answer
Select max salary from each department in sql
SQL
1 vote146 views1 answer
Unique vs distinct sql
SQL
1 vote175 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL

Share