摘要:
select * from z_leave where z_id in -- 检索重复z_linkname的纪录(select max(z_id) from z_leave where z_linkname in -- 求重复z_id的其中一个z_id(select z_linkname from z_leave group by z_linkname having count(1) >= 1) -- 取出重复的z_linknamegroup by z_linkname) 阅读全文