SQL, the opposite of SELECT DISTINCT? 2

[SoupXVII]

I know how to use select distinct, but I would like to select "non-distinct" records, those that have duplicate values in a given field. How is that possible in SQL?

 

[Maquis]

Use a group by query with a count on the field with the dups. Then select only the records with count > 1.

Something like this:

SELECT * FROM <tablename>
WHERE dupfield In (SELECT dupfield
FROM <tablename>
GROUP BY dupfield
HAVING Count(dupfield)>1);
Maq
<insert witty signature here>