Hi folks:

OS: Windows2000 Pro
DB: SQL 2000

Say: A table like below:

SN Status Datetime
001 pass 2007/11/05 01:30AM
002 fail 2007/11/05 01:50AM
002 pass 2007/11/05 02:00PM
003 fail 2007/11/05 02:30PM
003 fail 2007/11/05 03:00PM
003 fail 2007/11/05 03:15PM
004 pass 2007/11/05 03:30PM
.... ..... .........

Now what I want to get by using SQL is the amounts of records that repeated in the table above, the result that I want to get is: 2 , that is to say : there are two SNs that are repeated (002,003).

Could anybody please help me on how to achieve this??

Any help would be great appreciate !

Thanks in advance !