Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Frequency Count
Bertie Brink wrote:
> I have three columns containing buyers ages for three products.
>
> prod 1 prod2 prod3
>
> 34 23 45
> 34 22 34
> 54 44 45
> 23 22 45
> 45 22 34
>
>
> Can someone provide a SQL query to provide the frequency of every age
> per column?
Search for: ANALYTIC FUNCTIONS
You need to do your own schoolwork.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Aug 03 2006 - 16:51:04 CDT