SELECT *
FROM (SELECT regcode, COUNT(*) AS nNumber
FROM z1
GROUP BY regcode) DERIVEDTBL
WHERE (nNumber > 1)
选择员工表里名字相同的记录
ELECT *
FROM users
WHERE (name IN
(SELECT name
FROM users
GROUP BY name
HAVING COUNT(*) > 1))
ORDER BY name DESC