SQL code to get min,max at a time

Question

How to display min and max salary from a table at a time (2 records at a time, one with max and another with min)?

My input table data:

empid  ename sal
1       A    2000
2       B    1000
3       C    1500
4       D    5000
5       E    7000

Output:

sal
7000 -- max
2000 -- min

I've improved the formatting (for better reading). What did you try already? Show your code attempts. — Thomas Fritsch, Nov 01 '17 at 11:14

hbourchi · Answer 1 · 2017-11-01T11:25:16.083

0

You mean something like this?

select max(sal) sal from my_table union all select min(sal) sal from my_table

edited Nov 01 '17 at 11:25

answered Nov 01 '17 at 11:18

hbourchi

score 0 · Accepted Answer · answered Nov 01 '17 at 11:22

0

You can just use a Union:

Select MAX(Sal)
From TableA

UNION ALL

Select Min(Sal)
From TableA

This would give you your desired output:

sal
7000 -- max
2000 -- min

More information on Unions can be found here.

answered Nov 01 '17 at 11:22

Tom

2 Answers2