/SQL/Above average salary in sql

Above average salary in sql

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

Above average salary in sql

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

0

Similar codes

1 vote98 views1 answer
Oracle select first result
SQL
1 vote108 views1 answer
Mysql date diff in seconds
SQL
0 vote132 views1 answer
Insert into table with only identity column
SQL
0 vote145 views1 answer
Count column of tables psql
SQL
15 votes110 views2 answers
How to drop database name in postgresql
SQL
4 votes105 views2 answers
Oracle set date format
SQL
1 vote99 views1 answer
Oracle rolling back transactions
SQL
0 vote121 views1 answer
Python sqlalchemy connection show server
SQL
0 vote154 views1 answer
Sql alter table add column if exists
SQL
0 vote104 views1 answer
Mysql streaming example
SQL

Share