> > > SELECT t.title, t.date, t.speed > FROM table t JOIN ( > SELECT title, MAX(speed) maxsp > FROM table > GROUP BY title) t2 ON t.title = t2.title > WHERE t.speed = t2.maxsp > ORDER BY t.title > > Couldn't have done without your suggestion. Here's a virtual 22 oz. of > cold, local Wisconsin beer to you. >
This will return multiple rows when there are several with the same speed. --- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264
