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]
|