/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 vote315 views2 answers
Postgresql get long running queries
SQL
0 vote327 views1 answer
Mysql persistence.xml
SQL
2 votes325 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote339 views1 answer
Add a new column into table
SQL
0 vote339 views1 answer
Oracle running queries
SQL
0 vote314 views1 answer
Joins vs includes
SQL
1 vote342 views2 answers
Mysql switch case
SQL
0 vote332 views1 answer
Extract sql from query object sqlalchemy
SQL
3 votes320 views1 answer
Select nextval from sequence sql
SQL
2 votes337 views2 answers
How to check database username and password in postgresql
SQL