SELECT
result.no,user.*
FROM
(
SELECT
no,
count(*) AS count
FROM
user
GROUP BY
no
HAVING
count > 1
) AS result
LEFT JOIN user ON user.no = result.no
mysql某个字段重复查询出来
SELECT
result.no,user.*
FROM
(
SELECT
no,
count(*) AS count
FROM
user
GROUP BY
no
HAVING
count > 1
) AS result
LEFT JOIN user ON user.no = result.no
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
