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