I want to use:
select column1, column2, max(column3) as maximum from table_name group by
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.
|• grouping||Octavian Rasnita||10 Feb|
| • Re: grouping||Peter Brawley||10 Feb|