蓝派网(www.lan27.com)-精选网络资源,分享和交流! 文章首页站内搜索在线手册广告代码酷站欣赏万年历
您现在的位置: 蓝派网 >> 文章中心 >> 数据库 >> Access >> 正文

很实用的,查询重复数据

作者:佚名    文章来源:网络    更新时间:2008-6-3 21:06:19


select * from ka_info as a ,(select kahao from ka_info group by kahao having count(*)>1) b
where a.kahao =b.kahao ORDER BY A.KAHAO ASC

select distinct kahao,rfid from ka_info where kahao in
(select kahao from ka_info group by kahao having count(*)>1) order by kahao asc


发表评论】【打印此文】【关闭窗口】【点击数:
★好玩的休闲小游戏★