/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 vote343 views1 answer
Sql get missing id
SQL
18 votes377 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote1.7K views1 answer
Athena query timestamp greater than
SQL
3 votes388 views4 answers
Psql list tables in schema
SQL
1 vote373 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote376 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote357 views1 answer
How to open mysql in docker
SQL
0 vote423 views3 answers
Sql parenthetical expression examples
SQL
0 vote416 views1 answer
Sql query to select even numbers
SQL
0 vote352 views1 answer
Can we rollback deleted data in sql
SQL