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
