Hi, I want to use:
select column1, column2, max(column3) as maximum from table_name group by column 1;
Please tell me if the values from "column2" will contain the values from those records where the column3 has the maximum value. If it doesn't, please tell me how to do this as fast as possible. I know that I could get the maximum values, than make another query and get the values from the lines that have that max value, but I think this will take too much time.
Thank you. Octavian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]