List:General Discussion« Previous MessageNext Message »
From:Harald Fuchs Date:February 3 2006 9:10am
Subject: Re: How to Find the Max/Min from Multiple Columns (in each row)
View as plain text  
In article <31fbb4000602021028t2c5a4a33pb8c19623b1fb086e@stripped>,
Henry Chang <silverspin@stripped> writes:

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

[Others told you the answer for that]

> (I realize that each measurment should be it's own row, but I must use the
> table as it is.)

How about the following?

  CREATE VIEW mytblv AS
  SELECT id, measurement_01 AS measurement
  FROM mytbl
  UNION
  SELECT id, measurement_02
  FROM mytbl
  UNION
  SELECT id, measurement_03
  FROM mytbl

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