Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: help! In over my head
Thanks for the help.
Bob
aqs472_at_my-deja.com wrote:
> select field1,field2,count(*) from your_table
> group by field1,field2
>
> cheers,
> bb
>
> In article <3A3A79B0.A67C7DB4_at_mci.com>,
> Bob McConnell <bob.mcconnell_at_mci.com> wrote:
> > Help!
> > How can I count the number of occurrances of data from 2 fields?
> >
> > I have a table like this:
> > field1 field2
> > a b
> > a c
> > a b
> > a d
> > a c
> > b a
> > b c
> > b a
> >
> > And would like to get results that indicate a count for the
combination
> > of the 2 fields
> >
> > a b 2
> > a c 2
> > a d 1
> > b a 2
> > b c 1
> >
> > Also are there any good books on doing more complicated query design?
> >
> > thanks,
> > Bob
> >
> >
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 20 2000 - 13:35:56 CST