/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 vote259 views1 answer
Insert value in identity
SQL
0 vote235 views1 answer
Test connection to sql server
SQL
0 vote243 views1 answer
Setval in postgres
SQL
1 vote231 views2 answers
Replace text in sql
SQL
5 votes237 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote241 views1 answer
Intellij idea add mysql connector
SQL
0 vote199 views1 answer
Flask_sqlalchemy install
SQL
2 votes237 views1 answer
Wait delay in sql server
SQL
0 vote221 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote259 views2 answers
How to count codition
SQL