/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

11 votes128 views1 answer
Oracle export view ddl
SQL
0 vote109 views1 answer
How to count null values in sql
SQL
-1 vote115 views1 answer
Spring boot mysql connection properties
SQL
1 vote119 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote112 views1 answer
Watch mysql command line
SQL
1 vote86 views1 answer
Can we drop a primary key
SQL
1 vote103 views2 answers
T-sql random number for each row
SQL
0 vote135 views2 answers
Starts and end with vowel sql
SQL
1 vote109 views1 answer
Psql connections
SQL
0 vote127 views1 answer
Less than date query sqlachemy
SQL