/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 vote309 views1 answer
Returning with sqlalchemy
SQL
8 votes312 views4 answers
How to calculate the age from date of birth in python
SQL
42 votes376 views6 answers
Install beautifulsoup
SQL
0 vote294 views2 answers
Sql regex vowel
SQL
0 vote317 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
5 votes370 views3 answers
Create function in postgresql
SQL
0 vote318 views1 answer
Mysql cli output to a file
SQL
2 votes335 views1 answer
How to find table table in stored procedure sql server
SQL
17 votes323 views6 answers
What is cursor in sql server with example
SQL
0 vote320 views2 answers
Functions with parameters SQL
SQL