Re: duplicate rows problem with a twist
Date: Wed, 15 Jan 2003 15:37:10 GMT
Message-ID: <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 - 16:37:10 CET