Re: SQL count problem

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 14 Jan 2000 15:29:02 GMT
Message-ID: <85nfbu$p4m$3@news.seed.net.tw>

Frank Heijmans <no_ftgh_at_xs4all.nl_spam> wrote in message news:387deca0.26725177_at_news.xs4all.nl...
> Hi,
>
> I am looking for an SQL solution to do a frequency count
> on a table. My table could look like this:
>
> regnr amount
> -------------------------------
> 123 100.00
> 345 50.00
> 456 60.00
> 123 25.00
> 456 15.00
> 123 200.00
>
>
> The count should give me the following result
>
> frequency tot_amount
> --------------------------------
> 3 225.00
> 2 85.00
> 1 15.00
>
>
> Is this possible in one query? If so, can someone help me?

No.
What do you want to do? What's your requriment? Don't leave as a muzzy quiz.
Without knowing your requriment clearly, no one can tell you anything. Received on Fri Jan 14 2000 - 09:29:02 CST