List:General Discussion« Previous MessageNext Message »
From:Aleksandar Ivanisevic Date:February 2 2006 9:21pm
Subject:Re: How to Find the Max/Min from Multiple Columns (in each row)
View as plain text  
select max(greatest(measurement_01, measurement_02, measurement_03)) 
from table

select min(least(measurement_01, measurement_02, measurement_03)) from table

Henry Chang wrote:
> Hello everyone,
>
> I have a table where measurement values are collected in mulitple columns.
>
> Table Schema
> ==========================================
> ID, measurement_01, measurement_02, measurement_03
> ==========================================
> 1, 300, 350, 325    (max is 350, min is 300)
> 2, 225, 275, 400    (max is 400, min is 225)
> 3, 100, 500, 300    (max is 500, min is 100)
> ==========================================
>
> My question is that for each row, what's the sql query that determine the
> max value and the min value from all the columns??
>
> (I realize that each measurment should be it's own row, but I must use the
> table as it is.)
>
> Any help would be most appreciated.
>
> Thanks!
>
> Henry
>
>   


Thread
How to Find the Max/Min from Multiple Columns (in each row)Henry Chang2 Feb
  • Re: How to Find the Max/Min from Multiple Columns (in each row)Peter Brawley2 Feb
  • Re: How to Find the Max/Min from Multiple Columns (in each row)Aleksandar Ivanisevic2 Feb
  • Re: How to Find the Max/Min from Multiple Columns (in each row)Harald Fuchs3 Feb