find above average salary earner in sql

Solutions on MaxInterview for find above average salary earner in sql by the best coders in the world

showing results for - "find above average salary earner in sql"

1SELECT FIRST_NAME, LAST_NAME
2FROM EMPLOYEES
3WHERE SALARY > (SELECT AVG(SALARY) FROM EMPLOYEES);

similar questions

find out the name highest salary sql get max salary from each department sql how to find top 3 salary in sql top 3 salary in sql find below average salary in sql average salary in sql how to get max salary in each department in sql find average salary earner in sql write a sql query to print the name of employees having salary in each department order by department in ascending order sql find second highest salary employee third highest salary in sql min salary in sql n highest salary in sql sql highest salary by location how to get specific salary in sql second highest salary in sql 3rd height salary sql get all employee of salary if more than in sql above average salary in sql how to find average in sql lowest salary in sql query to find 2nd largest salary in sql find lowest salary earner in sql 3rd highest salary in sql how to get second highest salary in each department in sql

queries leading to this page

sql select lower than avg names salary biger than other mysql find above average salary earner in sql find below average salary in sql salary greater than maximum salary of any department retrieve total salary of employee which is greater than 3e120000 above average salary in sql average salary in sql find the employee whose salary is greater than average salary find the employee whose salary is greater than average salary using having list the employye name whose salary is gretear is then the average salary of dept find above average salary earner in sql