SELECT *FROM 表名

WHERE (列名 IN (SELECT [列名]

FROM 表名 列名

GROUP BY 列名,列名 HAVING COUNT(列名)>1))

ORDER BY 列名以下是示例:

SELECT * FROM authors

WHERE (au_lname IN (SELECT au_lname FROM AUTHORS au_lname

GROUP BY au_lname, au_lname

HAVING COUNT(au_lname) > 1))

ORDER BY au_lname