INSERT INTO #TABLE1 SELECT 'a',1
UNION ALL SELECT 'b',34
UNION ALL SELECT 'c',5
UNION ALL SELECT 'd',65
select col1,col2 from #TABLE1 where col2=(select max(col2) from #TABLE1)
select a.col1,a.col2,b.col1,b.col2 from #TABLE1 a,#TABLE1 b
where a.col2=(select max(col2) from #TABLE1)
and b.col2=(select min(col2) from #TABLE1)