/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

5 votes348 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
1 vote324 views1 answer
Float precision in psql
SQL
0 vote363 views1 answer
Pl sql disable trigger
SQL
5 votes315 views2 answers
Oracle timestamp to date
SQL
1 vote318 views1 answer
Postgresql last element of array
SQL
28 votes300 views4 answers
Mysql delete database
SQL
3 votes324 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
8 votes354 views2 answers
How to fetch data from database without last column
SQL
0 vote351 views1 answer
Querry mysql by 2 columns
SQL
15 votes344 views3 answers
Postgresql change column type
SQL

Share