Slightly difficult select query

[srfdriver22]

Hey all,

I need some help coming up with a mysql select query. I have a table that contains laptimes, what vehicle was used and at what track. I would like to get the fastest lap time per track and then per vehicle.

So, say Bob does a 1:11 in his Corvette at Daytona, a 1:10 in his Viper at Daytona and then a 1:13 in his Porsche at Daytona. The output would be:

Daytona

1:10 Viper
1:11 Corvette
1:13 Porsche

I must note that this database table has more than just the best lap times, it contains ALL of his laptimes, ever. So, I would need to get the MIN(laptime) per vehicle, per track.

Thanks for any help. 🙂

[TheIceman5]

select car, MIN(laptime) from mytable group by car, track

[srfdriver22]

Hmm, I get an error querying the database on that.