/SQL/Find below average salary in sql

Find below average salary in sql

Find below average salary in sql

SELECT first_name, salary FROM employees
WHERE salary <= (SELECT AVG(salary) FROM employees);

0

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

Similar codes

0 vote361 views1 answer
Ms sql print more than 1 variable
SQL
9 votes350 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote397 views1 answer
Postgres foreign key multiple columns
SQL
1 vote332 views1 answer
Mysql show current queries
SQL
4 votes382 views2 answers
Sqlalchemy_database_uri for mysql
SQL
1 vote396 views1 answer
Postgres see sequence current state
SQL
11 votes356 views2 answers
Insert date sql
SQL
1 vote383 views1 answer
Print all records of table in mysql
SQL
0 vote407 views1 answer
Sql check if field is not null
SQL
0 vote360 views1 answer
Tsql delete all rows
SQL

Share