/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 vote213 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote202 views1 answer
How to avoid duplicate records in sqlite
SQL
0 vote213 views1 answer
How to add session data into mysql database from button
SQL
2 votes234 views1 answer
Install postgresql centos 5
SQL
1 vote207 views2 answers
Oracle list partitioned tables
SQL
1 vote201 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception
SQL
0 vote215 views1 answer
Oracle sql number to varchar2
SQL
0 vote225 views1 answer
Change filed order in mysql
SQL
2 votes162 views1 answer
Oracle current date without time
SQL
1 vote212 views2 answers
Drop function in sql
SQL

Share