/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 vote139 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote122 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote112 views1 answer
Oracle 11g forget password
SQL
0 vote146 views1 answer
Selecting all columns from table sql database
SQL
0 vote117 views1 answer
Postrgres trunc
SQL
-1 vote114 views3 answers
Mysql get age from date
SQL
0 vote132 views1 answer
How to login to mysql in homestead
SQL
2 votes135 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote144 views2 answers
How to see table associated with a schema in sql
SQL
3 votes137 views2 answers
Oracle apex view logs
SQL

Share