/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 vote155 views1 answer
Su: Authentication failure mysql
SQL
1 vote153 views3 answers
Sql union
SQL
0 vote157 views1 answer
Oracle c# multiple update sql
SQL
1 vote182 views1 answer
Print year of a date sql
SQL
1 vote160 views1 answer
Mysql select update same table
SQL
1 vote150 views2 answers
Pl sql case
SQL
1 vote144 views1 answer
Create sample data postgresql
SQL
0 vote214 views1 answer
Check user sql password from command line
SQL
0 vote154 views1 answer
Traccar mysql
SQL
0 vote151 views1 answer
Will graphql replace sql
SQL