/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 vote346 views1 answer
How to print sql query
SQL
6 votes313 views5 answers
Mysql get last insert id
SQL
0 vote332 views1 answer
Postgresql create table many-to-many
SQL
0 vote306 views1 answer
Mysql docker image for macbook m1
SQL
3 votes332 views2 answers
Postgres inner join vs join
SQL
1 vote326 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
14 votes328 views3 answers
Alter foreign key
SQL
1 vote320 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote309 views1 answer
Criteria builder select subset of column
SQL
28 votes337 views6 answers
Foreign key
SQL