/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 vote124 views1 answer
Mysql repair a table
SQL
2 votes128 views1 answer
Import database in mysql command line xampp
SQL
6 votes156 views2 answers
Clear a table in mysql
SQL
2 votes199 views1 answer
Mysql create user with remote access
SQL
8 votes144 views2 answers
Grant all privileges database postgres to user
SQL
3 votes128 views4 answers
Order by desc postgres
SQL
2 votes164 views3 answers
3 days back in sql server
SQL
7 votes98 views1 answer
Alter table add key sql
SQL
0 vote146 views1 answer
Count database access django
SQL
15 votes131 views3 answers
Mysql update add to existing value
SQL

Share