/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

0 vote292 views1 answer
Sql select random procentage from rows
SQL
1 vote287 views1 answer
What is int in mysql
SQL
15 votes278 views2 answers
Open postgress in terminal mac
SQL
1 vote239 views1 answer
Oracle boolean to varchar
SQL
0 vote281 views1 answer
Output table plsql
SQL
0 vote287 views1 answer
Mysql set column equal to another automatic
SQL
0 vote293 views1 answer
T-SQL Never ending DELETE
SQL
6 votes304 views2 answers
How to get yesterday date in mysql
SQL
0 vote322 views1 answer
Pl sql disable trigger
SQL
0 vote293 views1 answer
Max mysql
SQL