/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

17 votes343 views3 answers
Postgresql list users
SQL
1 vote299 views2 answers
How to search date in sql query
SQL
0 vote292 views1 answer
Cannot start database server xampp mac os
SQL
1 vote292 views1 answer
Sql avg group by
SQL
2 votes320 views1 answer
Creating a view SQL
SQL
0 vote289 views1 answer
Get only structure database mysql
SQL
0 vote323 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
1 vote236 views1 answer
Oracle compile schema
SQL
7 votes295 views6 answers
Reset identity column in sql server
SQL
6 votes275 views1 answer
Rank function in oracle with example
SQL

Share