/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 vote198 views1 answer
Implizite joins sql
SQL
0 vote200 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote242 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote211 views1 answer
Get employees if not contains in sql
SQL
21 votes202 views1 answer
SQL cheat sheet pdf
SQL
0 vote209 views1 answer
Java nosql sort
SQL
0 vote192 views1 answer
Truncate table sql server foreign key
SQL
0 vote234 views1 answer
Mysql conf.d exampel
SQL
1 vote207 views1 answer
Raise application error in oracle
SQL
0 vote196 views1 answer
How to reset AI in sql
SQL