/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

1 vote171 views1 answer
Sql server today minus n
SQL
15 votes178 views2 answers
Select where duplicate mysql
SQL
1 vote159 views1 answer
Using SQL in rails migration
SQL
0 vote181 views4 answers
Mysql desactivar trigger
SQL
0 vote161 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote168 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote164 views1 answer
Table values functions in SQL
SQL
3 votes186 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
1 vote128 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
16 votes186 views5 answers
Select last row in sql
SQL