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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
