Re: how do i applying an equation to every row of a result set?

Hi, This might work for you but with two quries: SELECT @minval := least(min(colOne),min(colTwo)) FROM myTable; SELECT colOne-@minval FROM myTable; Anvar. At 06:26 PM 19/04/2002 -0400, you wrote: I am trying to normalize a data set based on the minimum values of certain columns. I figured

how do i applying an equation to every row of a result set?

I am trying to normalize a data set based on the minimum values of certain columns. I figured out that I can get the minimum value using a query like SELECT least(min(colOne),min(colTwo)) FROM myTable Is there a way I can do the normalization in a single query? Ideally, something like... SELECT