Re: SQL counting to see trend

On 2 Oct 2001 17:41:40 -0700, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>ok, in light of your comments below -- it might be that this in fact the answer
>to #2 and #1 is a single row:
>
>select avg(count(*))
> from t
> where ....
> group by trunc(time);
>
>that'll get the avg count for you.

>>I am going to try your suggested queries, though I am not exactly sure
>>yet what do you mean by "t"? Is it some special table, or rather
>>simply the abbreviation for the applicable table?
>>The table I use is called "LOG".
>>
>
>T just stands for "table" -- you use your tablename there...

Though with some delay, I thank you again, Tom.

With regards
Thomas

>Thomas Kyte (tkyte_at_us.oracle.com) http://asktom.oracle.com/
>Expert one on one Oracle, programming techniques and solutions for Oracle.
>http://www.amazon.com/exec/obidos/ASIN/1861004826/
>Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Sun Oct 28 2001 - 15:33:52 CET