oracle的使用技巧

1.记录去重

 

delete from tlbb.tlbb_bind_log 
where rowid not in (select max(rowid) 
					from tlbb.tlbb_bind_log 
				   where BUY_TIME >= to_date('2012-07-10', 'yyyy-mm-dd') 
					 and BUY_TIME < to_date('2012-07-12', 'yyyy-mm-dd') 
				   group by sn) 
and BUY_TIME >= to_date('2012-07-10', 'yyyy-mm-dd') 
and BUY_TIME < to_date('2012-07-12', 'yyyy-mm-dd');