/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 vote330 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote395 views1 answer
Parent and child link in mysql
SQL
1 vote334 views2 answers
Mysql filter by date mount
SQL
31 votes312 views3 answers
Sql count
SQL
3 votes332 views2 answers
Host is not allowed to connect to this mysql server
SQL
0 vote320 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote337 views1 answer
Java nosql sort
SQL
0 vote339 views3 answers
Osx stop mysql service
SQL
1 vote325 views1 answer
Oracle index partition
SQL
0 vote320 views1 answer
Add timestamp column to existing table ms sql server
SQL