/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

6 votes119 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote114 views1 answer
Base64 encode sql server
SQL
0 vote120 views1 answer
Nodejs sql get one to many relationship as array
SQL
1 vote98 views1 answer
Mysql count all table rows
SQL
0 vote105 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote110 views1 answer
Fast sql column count
SQL
-1 vote119 views1 answer
Mysql change database charset and collation
SQL
0 vote122 views1 answer
Psql check table fields
SQL
0 vote116 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote111 views1 answer
Pl sql disable trigger
SQL