Thread
:
Find the minimum or maximum value across several columns?
View Single Post
#
5
(
permalink
)
03-29-2007, 04:42 PM
Vj
Posts: n/a
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]
Vj