/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 vote196 views1 answer
Automated psql csv export script on windows
SQL
0 vote178 views1 answer
Enable sql server full text indexing
SQL
3 votes155 views1 answer
Oracle nextval
SQL
0 vote217 views1 answer
Sql server rtrim everything after character
SQL
0 vote126 views1 answer
Procedures and functions in pl/sql
SQL
0 vote193 views1 answer
Plsql check for string in numeric
SQL
1 vote240 views1 answer
Show databases mysql docker
SQL
0 vote215 views1 answer
Drop a view in sqlite
SQL
0 vote210 views1 answer
Two inner joins sql
SQL
0 vote175 views1 answer
Databricks install odbc driver connect to sql server
SQL