mysql 重复记录
SELECT
*,_rowid
FROM
jk_his_zybrcryxxb a
WHERE
(a.brid, a.zycs,a.ryrq) IN (
SELECT
brid,zycs,ryrq
FROM
jk_his_zybrcryxxb
GROUP BY
brid,zycs,ryrq
HAVING
count(*) > 1
)
posted on 2022-07-15 09:10 zyp_java_net 阅读(14) 评论(0) 编辑 收藏 举报