/SQL/How to find max and min salary in sql

How to find max and min salary in sql

SELECT MAX(SALARY) FROM EMPLOYEES
UNION
SELECT MIN(SALARY) FROM EMPLOYEES;

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);

Similar codes

3 votes186 views1 answer
Fk in insert mysql
SQL
0 vote189 views1 answer
Guid string to binary better
SQL
1 vote158 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote208 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
2 votes210 views2 answers
Calculate percentage in sql
SQL
0 vote207 views1 answer
Find how many tables in database sql query
SQL
0 vote181 views1 answer
C# check if mysql query modified rows
SQL
0 vote214 views1 answer
Connect laravel to mysql on mac
SQL
2 votes193 views1 answer
Postgresql drop primary key constraint
SQL
0 vote177 views1 answer
Mysql find db contarint
SQL