rning multiple rows in only one col to an aggregate function.
Thanks and bye,
Bernhard
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 2:34 PM
Subject: Re: Subselect in aggregate function in My
[EMAIL PROTECTED] wrote:
>
> Hi,
>
> I have some logging data from a webserver in a table and want to do some
> analysis.
> I infact want to see how many files are requested at one time.
> To do this I
> SELECT COUNT(time) anz FROM table GROUP BY time ORDER BY anz DESC
> This gives me the number
Hi,
I have some logging data from a webserver in a table and want to do some
analysis.
I infact want to see how many files are requested at one time.
To do this I
SELECT COUNT(time) anz FROM table GROUP BY time ORDER BY anz DESC
This gives me the number of requests at any time. I now want to see
