/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 vote124 views1 answer
Java sql connection
SQL
1 vote115 views1 answer
Set id count mysql
SQL
0 vote136 views1 answer
Create a sql server database programmatically
SQL
0 vote121 views1 answer
Sql gap missing values
SQL
0 vote140 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
2 votes173 views1 answer
Oracle block
SQL
1 vote146 views1 answer
OSError: mysql_config not found
SQL
1 vote134 views1 answer
Postgres start database on linux
SQL
0 vote174 views1 answer
Do you know sql
SQL
0 vote178 views1 answer
Postgres dump sql insert
SQL