Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 11 to 12 of 12 total

Get the correct matching value for min(xxx) using group by...

Fri, Feb 29 2008 8:36 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Felix, << An example: from this table >> Okay, I see the problem. I assumed that you wanted the fastest time on a particular day, not the fastest time overall, and then including the date also. To do what you want, Charle's version of the query will work just fine. -- Tim Young Elevate Software www.elevatesoft.com
Fri, Feb 29 2008 9:07 AM	Permanent Link
Felix	Charles << Does this do what you want? select a.Strecke, a.Datum, a.Zeit from Laufen a where a.Zeit = (select min(Zeit) from Laufen b where b.Strecke=a.Strecke) >> It does exactly what I want. Thanks a lot. I wouldn't have hit on this for years. Cheers Felix

« Previous Page	Page 2 of 2
Jump to Page: 1 2