摘要:
用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 阅读全文