ORACLE中查询重复记录的应用及效率对比
1.0.621 Secsselect a.dwbm,a.grxh,a.xm from yw_ick a,yw_ick b where a.dwbm=b.dwbm and a.grxh=b.grxh and a.rowid2.4.337 Secsselect dwbm||,||grxh,count(dwbm||,||grxh)from yw_ickgroup by dwbm||,||gr
原创
2005-09-02 14:22:00 ·
1507 阅读 ·
0 评论