/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 vote302 views1 answer
Myql find duplicates
SQL
1 vote270 views3 answers
Grant syntax in sql
SQL
0 vote297 views4 answers
Restart MySQL
SQL
0 vote301 views1 answer
Mysql last friday of current month
SQL
1 vote297 views2 answers
Snowflake alter column data type
SQL
12 votes261 views1 answer
How to change the value of a table in sql
SQL
0 vote270 views1 answer
Sql cheetsheet
SQL
1 vote291 views1 answer
Oracle sql first day of year
SQL
3 votes301 views2 answers
Sqlite show table structure
SQL
20 votes270 views4 answers
Reset auto increment in MySQL
SQL

Share