/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

9 votes163 views3 answers
Date format in sql
SQL
0 vote132 views1 answer
Mysql streaming example
SQL
1 vote128 views1 answer
How to open closed port mysql in ubuntu
SQL
9 votes129 views4 answers
SQL Date Format
SQL
0 vote129 views1 answer
Copy Table from SQL to CSV
SQL
1 vote97 views1 answer
Import in mysql without a software
SQL
3 votes183 views1 answer
Oracle function
SQL
1 vote126 views1 answer
How to test for sql injection
SQL
1 vote271 views3 answers
Sql subquery
SQL
0 vote164 views5 answers
Right join
SQL

Share