Home Forums SQL Server 2005 T-SQL (SS2K5) GREATEST and LEAST function RE: GREATEST and LEAST function
hs_abed
SSC Enthusiast
Points: 117
More actions
November 20, 2013 at 7:37 am
#1667815
With Query1 As
( Select * from (values (1, 2), (4, 5), (2, Null), (2, 7), (1, 8)) As T(x,y))
select MAX(x) Greatest, Min(x) Least From Query1
Union All
Select Max(y), MIN(y) From Query1