Set function SQL Help

I need to write an SQL statement that gets the minumum value of an average, plus return an Id that is associated with that minimum average.

Something like:
select min( avg(avg_round_trip_time) )
from stats
group by id

But have id in the select:
select id, min( avg(avg_round_trip_time) ) from stats
group by id

Is there a way to accomplish this with SQL?

Thanks,
Jim

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 01 2000 - 14:36:23 CST