/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 vote140 views1 answer
Oracle list partitions
SQL
10 votes138 views3 answers
Sql check double value
SQL
4 votes152 views3 answers
NOT NULL SQL
SQL
1 vote122 views1 answer
Drop table if exists oracle
SQL
0 vote150 views1 answer
How to fetch data from database in sql
SQL
13 votes132 views1 answer
Views in sql
SQL
0 vote142 views4 answers
What is unique key in sql
SQL
0 vote177 views1 answer
T-sql delete view if exists
SQL
0 vote124 views1 answer
Show database not empty tables postgres
SQL
0 vote146 views1 answer
Truncate a table then insert data
SQL