/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 vote268 views1 answer
Set open file limit mac catalina mysql
SQL
25 votes341 views5 answers
Mysql replace text
SQL
0 vote298 views2 answers
Mysql show foreign keys
SQL
-1 vote257 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
25 votes296 views6 answers
How to change column name in mysql
SQL
0 vote276 views1 answer
Rename view mysql
SQL
0 vote294 views1 answer
Sqlite3_open_v2
SQL
0 vote260 views1 answer
Left join in codeigniter query builder
SQL
0 vote274 views1 answer
Postgresql using reserved word as column name
SQL
0 vote638 views1 answer
Sql field equals multiple values
SQL