View Single Post
  #7 (permalink)  
Old 06-18-2008, 09:31 AM
Robert from Czech
 
Posts: n/a
Default ANY answer. Re: Find the minimum or maximum value across several columns?

One math solution:

For Min try:
[SQL]
SELECT
Min((Col1 + Col2 - Col1 * SIGN( Col1 - Col2 ) - Col2 * SIGN( Col2 - Col1 ) ) DIV 2) AS MinVal
FROM table_name;
[/SQL]For Max try:
[SQL]
SELECT
Max((Col1 + Col2 - Col1 * SIGN( Col2 - Col1 ) - Col2 * SIGN( Col1 - Col2 ) ) DIV 2) AS MaxVal
FROM table_name;[/SQL]
Reply With Quote