/SQL/Average salary in sql

Average salary in sql

Average salary in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY = (SELECT AVG(SALARY) FROM EMPLOYEES);

0

Find below average salary in sql

SELECT first_name, salary 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 vote104 views1 answer
Oracle user last connection date
SQL
0 vote116 views1 answer
Allow null in psql
SQL
0 vote115 views1 answer
Oracle insert single quote in string
SQL
1 vote102 views1 answer
Postgres killing connections on db
SQL
1 vote121 views2 answers
This month mysql where
SQL
2 votes104 views1 answer
Anonymous block plsql
SQL
5 votes105 views2 answers
Oracle list columns
SQL
4 votes97 views1 answer
Mysql set max connections
SQL
5 votes116 views1 answer
Oracle nls instance
SQL
1 vote91 views1 answer
Mysql size int
SQL

Share