min and max salary and name in sql

Solutions on MaxInterview for min and max salary and name in sql by the best coders in the world

Search
showing results for - "min and max salary and name in sql"
Noan
03 Sep 2016
1SELECT FIRST_NAME , SALARY
2FROM EMPLOYEES
3WHERE SALARY IN (SELECT MAX(SALARY)AS RESULT FROM EMPLOYEES
4UNION
5SELECT MIN(SALARY)AS RESULT FROM EMPLOYEES);
similar questions
third highest salary in sqlsql display max value3rd highest salary in sqlget max salary from each department sqlwhere date 3d max 28date 29 in sqlmax 3 salary in sqlfirst max salary in sqlsql max countlowest salary in sqlhow to find max and min salary in sqlquery to find 2nd largest salary in sqln highest salary in sqlfind second max salary query sql2nd max salary query in sqlsql where max datesql min and max in same querysql max value in columnhow to get max from each department in sqlsql highest salary by locationfind out the name highest salary sqlsecond max salary in sqlmin max sqlhow to get max salary in each department in sqlsecond highest salary in sqlfind max number in sqlmin salary in sqlmaximum element in sqldifference between min and max date sql
queries leading to this page
third highest salary in sqlwrite a query to find out minimum salary in each departmentfind maximum salary and 2nd minimum salary in sqlhow to find max salary and equivalent name in sqlhow to max salary in a table sqlfinding max salary sql2 minimum and maximum salary in sqlhow to get max of salary in sqlmax 3 salary in sqlmaximum and minimum salary in sqlmax of salary in sqlfind max salary in sqlhow to find maximum and minimum and avg salaries of department in sqltop min salary in sql from max 5 salaryhow to find max and min salary in sqlmax salary with name in sqlhow to find max paid salary in sqlsql query to get max salarysql query for max salaryhow to get the name that has max salary in sqlhow to find min salary in sqlhow to find max salary and name in sqlget the max salary in sqlhow to get max and min salary per departmentsql print max and min salarysql max salarymin max salary in sqlhow to find max salary in sqlquery to find max salary in sqlfind out the max salary in sqlquery for max salary in sqlmin salary in sqlmin and max 28salary in sql 29min and max salary and name in sqlmin average max 28salary in sql 29max salary in sqlmin and max salary and name in sql