Re: help! In over my head

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 Fri Dec 15 2000 - 15:20:45 CST