Re: getting rows with max values.

2001-04-19 Thread Benjamin Pflugmann
Hi. On Thu, Apr 19, 2001 at 02:27:09PM -0700, [EMAIL PROTECTED] wrote: > This may have been covered in the past; but, marc.theaimsgroup isn't > responding so I can't run my normal search. This is even covered in the fine manual ;-) http://www.mysql.com/documentation/mysql/bychapter/manual_Tutori

getting rows with max values.

2001-04-19 Thread Seth Northrop
This may have been covered in the past; but, marc.theaimsgroup isn't responding so I can't run my normal search. I'm trying to extract rows with max values within unique groups - NOT just the max values. In very watered down terms: Given: CREATE TABLE test_table ( number tinyint(1) unsigned