/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

5 votes164 views4 answers
Start postgres server
SQL
1 vote151 views2 answers
Extract weekday from date in sql
SQL
0 vote148 views1 answer
Oracle current timestamp insert statement
SQL
0 vote181 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
1 vote138 views1 answer
Floor function in sql oracle
SQL
0 vote204 views1 answer
MySQL update with subquery
SQL
0 vote152 views1 answer
Update one column from another column in same table
SQL
4 votes160 views1 answer
Adding data to table in sql python
SQL
0 vote145 views1 answer
What is the use of index in mysql table
SQL
0 vote151 views1 answer
Psql select * from table
SQL

Share