In article <37d61e27-c8a2-4724-8b0b-55f925d5b167
@t39g2000prh.googlegroups.com>, hooperc2...@yahoo.com says...>
> On Oct 31, 10:45 am, Jeremy <jeremy0...@gmail.com> wrote:Thanks Charles, exactly the sort of thing I was looking for.
> > Oracle 10g R2 10.2.0.1.0
> > Hi
> > I posted (couple of weeks ago) on this (as a sub-thread) but wanted to
> > Say we have a table with date/time related data
> > create table hits
> > And our data look like this:
> > date_time ip_address
> > I want to produce a report that shows the number of hits per minute but
> > So I would like to see:
> > date_time hits
> > Is it possible without outer-joining to another table with "time" data
> You need a way to generate rows with the missing time elements, for
> With a slight modification to the above:
> Once the rows with the missing time elements are available, you could
> There are of course more than 1000 minutes in a day (right around
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.