Need help with a query

[Sebbe]

Hi, could anybody help me to formulate a SQL query which retrives all posts where there's doublets of a specified field. Like if there's 2 posts which has the number 200 as ID for example, they would qualify, but if the id is unique it shouldn't qualify for the query.

Any help appriciated.

[Kid Charming]

SELECT
foo
,bar
,columnwithdups
FROM
table
GROUP BY
columnwithdups
HAVING
COUNT(columnwithdups) > 1