/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

16 votes134 views3 answers
Order by sql query
SQL
0 vote130 views1 answer
Safe mysql
SQL
0 vote127 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote117 views1 answer
Sql get guid
SQL
0 vote73 views1 answer
Procedures and functions in pl/sql
SQL
16 votes125 views3 answers
Update table from another table
SQL
3 votes119 views3 answers
Create table in microsoft sql server
SQL
0 vote120 views1 answer
Oracle remove line breaks
SQL
0 vote130 views1 answer
Disable database droping sql
SQL
0 vote156 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL