Answers for "max salary with name in sql"

SQL
1

how to find max and min salary in sql

SELECT MAX(salary), MIN(salary) FROM employees;
Posted by: Guest on May-09-2021
0

min and max salary and name in sql

SELECT FIRST_NAME , SALARY
FROM EMPLOYEES
WHERE SALARY IN (SELECT MAX(SALARY)AS RESULT FROM EMPLOYEES
UNION
SELECT MIN(SALARY)AS RESULT FROM EMPLOYEES);
Posted by: Guest on November-27-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language