View Single Post
  #5 (permalink)  
Old 03-29-2007, 04:42 PM
Vj
 
Posts: n/a
Default MS SQL answer. Re: Find the minimum or maximum value across several columns?

[sql]
select min(s.t) as minimum,max(s.t) as maximum from (select col1 as t from t1 union select col2 as t from t1) s
[/sql]
Reply With Quote