摘要: 用select语句,查询重复记录假设,表名为 T1 子段为 A,B,Cselect count(*) ,A,B,C from T1 group by A,B,C having count(*) > 1 测试数据: A100 B100 C100 A101 B101 C101 A102 B102 C102 A102 B102 C100 A102 B102 C102 A102 B102 C102 A100 B100 C100 运行结果:2 A100 B100 C100 3 A102 B102 C102 阅读全文
posted @ 2006-05-22 19:53 陕北蜂农 阅读(111) 评论(0) 推荐(0) 编辑