Re: Duration Question

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 2 Dec 2006 08:09:34 +0100
Message-ID: <457126ae$0$25745$426a74cc@news.free.fr>

<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 - 01:09:34 CST