/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 vote185 views1 answer
Edit shchima table in sql
SQL
0 vote168 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote177 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote186 views1 answer
Shortcut run sql pgadmin
SQL
0 vote182 views1 answer
Foreign key multiple columns
SQL
1 vote176 views1 answer
Oracle repeat_interval 5 minutes
SQL
5 votes199 views2 answers
Postgresql add not null constraint
SQL
0 vote171 views2 answers
Sql join on wildcard
SQL
0 vote183 views1 answer
Sql query tags
SQL
0 vote182 views1 answer
Postgres read table structure
SQL

Share