List:General Discussion« Previous MessageNext Message »
From:Octavian Rasnita Date:February 10 2007 11:39am
Subject:grouping
View as plain text  
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

Thread
groupingOctavian Rasnita10 Feb
  • Re: groupingPeter Brawley10 Feb