how to find max and min salary in sql

Solutions on MaxInterview for how to find max and min salary in sql by the best coders in the world

showing results for - "how to find max and min salary in sql"
Serena
03 Feb 2019
1SELECT MAX(salary), MIN(salary) FROM employees;
Thiago
29 May 2020
1SELECT MAX(SALARY) FROM EMPLOYEES
2UNION
3SELECT MIN(SALARY) FROM EMPLOYEES;
Fabio
12 Oct 2018
1SELECT FIRST_NAME , SALARY
2FROM EMPLOYEES
3WHERE SALARY IN (SELECT MAX(SALARY)AS RESULT FROM EMPLOYEES
4UNION
5SELECT MIN(SALARY)AS RESULT FROM EMPLOYEES);
queries leading to this page
third highest salary in sqlselect max salary sqlwrite a query to find out minimum salary in each departmenthow to get the maximum and minimum salary of employees in sqlsecond highest salary in sql using maxfind maximum salary and 2nd minimum salary in sqlsecond highest salary sql using maxquery to find and print max salary in sqlhow to print max salary in sqlhow to find max salary and equivalent name in sqlhighest maximum salary in sqlhow to max salary in a table sqlfind minimum salary in sqlhow to find min average max 28salary in sql 29find max salary from each department in sqlfinding max salary sqlget third highest salary using max 28 29 in sql2 minimum and maximum salary in sqlquery to find max salaryhow to get max of salary in sqlmax 3 salary in sqlsql qurey to find max salarymaximum and minimum salary in sqlmax and min salary from employee tablemax of salary in sql3rd highest salary in sql using maxfind max salary in sqlfind max salary from each department in sql without maxhow to find maximum and minimum and avg salaries of department in sqlhow to find max salary in sql from rowtop min salary in sql from max 5 salarymax second salary sqlhow to find max and min salary in sqlmax salary with name in sql3 max salary 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 sqlselect max salary in sqlfind 3rd max and 4th min salary in sql using limit3rd max salary in sqlhow to find min salary in sqlhow to find max salary and name in sqlget the max salary in sqlsql to find max salary in each departmenthow to print details of max salary in sqlsecond max salary in sqlhow to get max and min salary per departmentsql print max and min salarysql max salarymin max salary in sqlwrite sql to find max salaryhow to find max salary in sqlhow to get max salary in each department in sqlquery to find max salary in sqlfind out the max salary in sqlquery for max salary in sqlhow to get maximum salary in sqlcount max salary in sqlmin salary in sqlget max salary from department sqlhow to find max average salary in sqlmin and max 28salary in sql 29maximum salary in sqlmin and max salary and name in sqlfind maximum salary in sqlmin average max 28salary in sql 29max salary in sqlhow to find max and min salary in sql