/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

8 votes210 views1 answer
Check mysql version phpmyadmin
SQL
0 vote197 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
8 votes232 views2 answers
How to fetch data from database without last column
SQL
0 vote260 views1 answer
A network or instance-specific error sql server
SQL
4 votes199 views1 answer
Restart for pg_hba.conf file
SQL
0 vote274 views1 answer
Generate sql from specific migration ef core
SQL
0 vote247 views2 answers
Search stored procedures
SQL
2 votes178 views1 answer
Codeigniter print last sql query
SQL
5 votes225 views3 answers
Day of week postgresql
SQL
0 vote204 views1 answer
Sql output select
SQL

Share