Oracle 查询重复记录的
摘要：
列子：Select name,num from test where rowid!=(select max(rowid) from test b where b.names=test.names andb.num=test.num);----------------------------------------- 速度优化，前一语句比后一语句的速度快几十倍select names,dates from test,bwhere test.names = b.names(+) and b.names is null and b.dates > date('2003-01-01 阅读全文
posted @ 2012-09-26 16:05 呼嘎嘎 阅读(154) 评论(0) 推荐(0) 编辑
