/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

4 votes51 views4 answers
Rollback in sql
SQL
3 votes78 views2 answers
Savepoint in sql
SQL
1 vote56 views1 answer
What is int in mysql
SQL
0 vote13 views2 answers
How to combine two sql queries in one result
SQL
2 votes57 views3 answers
Mysql unix timestamp to date
SQL
0 vote66 views1 answer
Influxdb clone measurement
SQL
2 votes60 views3 answers
How to check current user in mySQL
SQL
57 votes113 views6 answers
Sql alter table
SQL
0 vote57 views1 answer
What is between operator
SQL
0 vote64 views1 answer
Best way to bind parameters to SqlCommand C#
SQL

Share