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 -> Re: Averaging Query on Logging Table

Re: Averaging Query on Logging Table

From: The Ghost <Ghost_at_home.com>
Date: Sun, 23 Sep 2001 03:07:49 GMT
Message-ID: <9mcr7.37077$g45.15839413@news3.rdc2.on.home.com>


read sql documentation.

"Matt Morton-Allen" <m2_at_csu.edu.au> wrote in message news:Cjcr7.4$6f3.10675_at_news0.optus.net.au...
> Hi All,
> a quick question. I have a logging table ACCESS_LOG with a DATE_LOGGED and
a
> USERNAME field that contains one row for each logged action per user. I
want
> to find out an average of how many actions are performed by each user each
> day. That is I would like to be able to state that on average X actions
are
> performed by each user on a given day.
>
> Has anyone got any tips on how to get started? I am using Oracle 8.1.6.
>
> Matt.
>
>
Received on Sat Sep 22 2001 - 22:07:49 CDT

Original text of this message

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