SELECT
id, name
FROM
tableName
WHERE
name
IN
(
SELECT
name
FROM
tableName
GROUP
BY
name
HAVING
(
COUNT
(name )
>
1
))
ORDER
BY
name
转载于:https://www.cnblogs.com/yoyiorlee/archive/2010/10/09/1846949.html