/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 vote148 views1 answer
Sql comment header
SQL
0 vote101 views1 answer
Sql gather statistics to increase performance
SQL
0 vote124 views1 answer
SELECT statement to find the specific cell in database table
SQL
1 vote120 views1 answer
Show databases mysql docker
SQL
0 vote112 views1 answer
Oracle string substitution
SQL
94 votes122 views4 answers
Create database postgres
SQL
0 vote100 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote110 views1 answer
Two inner joins sql
SQL
13 votes106 views3 answers
Sql online code
SQL
1 vote116 views1 answer
Show structure of table in sql
SQL