/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

0 vote164 views1 answer
Dnsmasq.conf location macos
SQL
2 votes173 views1 answer
Can you use a where clause for a child query
SQL
0 vote189 views1 answer
Jdbc sql connection string
SQL
38 votes262 views6 answers
Ubuntu install mysql client
SQL
2 votes180 views1 answer
Oracle sql day of month from date
SQL
6 votes175 views2 answers
Find mysql version linux
SQL
6 votes184 views1 answer
Oracle desc table primary key
SQL
7 votes185 views1 answer
Postgres base size
SQL
0 vote201 views1 answer
Kotlin sqlite delete row
SQL
0 vote215 views1 answer
Connect laravel to mysql on mac
SQL

Share