Okay, I guess I could have been more specific - how would one go about
doing it?
It seems like it would be one of those SQL tricks.
Michel Cadot wrote:
> <dave.howland_at_gmail.com> a écrit dans le message de news: 1165033982.461507.272230_at_80g2000cwy.googlegroups.com...
> | Hello everyone:
> |
> | I have a db table that contains three pieces of information ( let's say
> | I was tracking car trips), a start time(date), an end time(date) and a
> | duration(int) What I want to know (two things) (a) in every hour of
> | every day, is there a way that I could tell the maximum number of
> | concurrent cars on the road? (b) what is the total number of cars on
> | the road in each hour?
> |
> | Can this be done is SQL?
> |
>
> Yes.
>
> Regards
> Michel Cadot
Received on Sat Dec 02 2006 - 10:25:30 CST
