Bill,

You could ty something like:

SELECT myKey, Count(*) AS Counter;
FROM MyTable;
GROUP BY myKey;
HAVING Counter > 1

to get all duplicate rows in the table


Cheers,

Zoran

>What's the SQL command to display only the duplicate rows in a table?