/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 vote294 views1 answer
Trigger stock phpmyadmin
SQL
1 vote274 views1 answer
Oracle add proxy
SQL
0 vote307 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
4 votes260 views2 answers
Oracle unliock account
SQL
0 vote267 views1 answer
Replace null value within column mysql
SQL
1 vote293 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote278 views1 answer
Replace content value from old to new sql
SQL
53 votes547 views6 answers
How to install mysql ubuntu
SQL
1 vote317 views1 answer
Oracle plan hash value
SQL
0 vote284 views1 answer
How to make full text search dynamic in mysql
SQL

Share