摘要: 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) 阅读全文
posted @ 2012-12-03 11:59 蜗牛、、、 阅读(148) 评论(0) 推荐(0) 编辑