Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL: Duration Question

SQL: Duration Question

From: <dave.howland_at_gmail.com>
Date: 1 Dec 2006 20:33:02 -0800
Message-ID: <1165033982.461507.272230@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? Received on Fri Dec 01 2006 - 22:33:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US