万物伊始...
select * from iw_user where cert_no in (select cert_no from iw_user group by cert_no having count(cert_no)=2)
一开始用>2,结果出来很多身份号码空的记录,这个问题的解决办法只能给cert_no定个范围或者等于多少,is not null居然不管用
posted on 2015-01-21 16:05 苦楝树 阅读(133) 评论(0) 编辑 收藏 举报
Powered by: 博客园 Copyright © 2024 苦楝树 Powered by .NET 8.0 on Kubernetes