/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 vote155 views1 answer
Sql create and grant user access to database
SQL
0 vote127 views1 answer
How to create notes in mysql
SQL
1 vote146 views1 answer
Psql connect
SQL
2 votes127 views1 answer
Mysql sysdate - 1 day
SQL
1 vote119 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote120 views1 answer
Distinct data types in a table sql query
SQL
0 vote124 views1 answer
What is metadata in sql
SQL
0 vote120 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote132 views1 answer
Linked server delete openquery
SQL
4 votes137 views1 answer
Adding data to table in sql python
SQL

Share