/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 vote238 views1 answer
How to use select union and loop
SQL
0 vote130 views1 answer
Min and max salary and name in sql
SQL
0 vote130 views1 answer
Create synonym for dblink in oracle
SQL
1 vote162 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote152 views1 answer
Space not removing from column in sql
SQL
0 vote149 views1 answer
Recently updated stored procedure in sql server
SQL
0 vote139 views2 answers
Greater than sql server
SQL
0 vote134 views1 answer
Sql query for getting data with join and count
SQL
1 vote135 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
0 vote148 views1 answer
Google sheets data validation custom formula filter
SQL

Share