/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 vote253 views1 answer
Create synonym for dblink in oracle
SQL
0 vote204 views1 answer
Mysql update sum same table
SQL
0 vote235 views1 answer
Mysql c commands
SQL
7 votes228 views1 answer
Connect mysql docker
SQL
1 vote219 views1 answer
Mysql column start with string
SQL
1 vote223 views1 answer
Oracle case
SQL
-1 vote232 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote226 views1 answer
How to open mysql in docker
SQL
11 votes251 views1 answer
Ddl view
SQL
0 vote226 views1 answer
Postgresql delete multiple rows
SQL