Henry,>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??SELECT ... GREATEST(col1,col2,...), /// PB ----- 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 |
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.0/248 - Release Date: 2/1/2006
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
