duplicate rows problem with a twist

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 - 14:37:43 CET