execuse me to ask this question concerning a SQL Statement, but I couldn't find some helping informations in the web concerning a little bit more complex SQL Statements (any hints welcome :-))
I have a table which contains sport results, e. g. columns - Person VARCHAR - Time VARCHAR (Format hh::mm.ss) - Date DATE
The filled table could look like: Person Time Date Me 1:00.00 2004-01-14 Me 2:00.00 2004-01-12 You 1:10.00 2004-01-13 You 1:20.00 2004-01-14
Now I want select the minimum time for each Person and need additional the information when this time was reached.
So expected result:
Me 1:00.00 2004-01-14 You 1:10.00 2004-01-13
I tried some queries with GROUP and HAVING, but I didn't manage it to work.
Thanks for any hints concerning this or where I could find some helpful informations.
Best regards
Hannes
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
