/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 vote298 views1 answer
Oracle last character of string
SQL
5 votes291 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote252 views1 answer
Copy table dbeaver
SQL
0 vote295 views1 answer
Can we rollback deleted data in sql
SQL
0 vote288 views1 answer
Alter session set nls_language french
SQL
2 votes320 views2 answers
Mysql alter column default
SQL
0 vote344 views1 answer
Sql ssrs
SQL
0 vote335 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote271 views2 answers
Spring properties file for db
SQL
2 votes350 views1 answer
Query to check cpu utilization in oracle database
SQL

Share