Re: duplicate rows problem with a twist

In the right spirit, Jim.

select count(count(*)) from my table group by field1, field2 having count(*)
> 1

"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message news:GefV9.61069$Dn.10821_at_sccrnsc03...
> How's this:
> select count(count(*)) from my table group by field1, field2
> Jim
>
> --
> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can
 figure
> it out.
> "s rao" <sujayrao2002_at_yahoo.com> wrote in message
> news:699596f3.0301150537.184722b0_at_posting.google.com...
> > hi all,
> >
> > how do i get the count of the total number of rows duplicated in a
> > table. i dont want to print all the rows and the duplicate counts of
> > each rows. i just want the count of the result.
> >
> > for example if two fields of the table are like this
> > Field1 Field 2
> > a b
> > a b
> > a b
> > c d
> > c d
> > e f
> >
> > then i want the result to print 2
> > and NOT
> > a b 3
> > c d 2
> >
> > thanks
>
>
Received on Wed Jan 15 2003 - 22:10:43 CET