Answers for "Display all the details of the employee whose salary is more than the Sal of any IT PROFF.."

SQL
0

find below average salary in sql

SELECT first_name, salary FROM employees
WHERE salary <= (SELECT AVG(salary) FROM employees);
Posted by: Guest on January-28-2021
0

above average salary in sql

SELECT FIRST_NAME FROM EMPLOYEES
WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);
Posted by: Guest on January-28-2021

Code answers related to "Display all the details of the employee whose salary is more than the Sal of any IT PROFF.."

Code answers related to "SQL"

Browse Popular Code Answers by Language