Thread: Find the minimum or maximum value across several columns?
View Single Post
  #4 (permalink)  
Old 05-11-2006, 07:30 AM
Dimitar
 
Posts: n/a
Default ANY answer. Re: Find the minimum or maximum value across several columns?
How about this?
[sql]
SELECT max(c) FROM
(SELECT col1 as c FROM t1
UNION
SELECT col2 as c FROM t1) as t2
[/sql]
Reply With Quote