删除重复数据：
delete a from T_OUTLET_HISTORY a
left join (
select max(N_ID) n_id,s_outlet_id,T_DATE from T_OUTLET_HISTORY
group by s_outlet_id,T_DATE) b on a.n_id=b.n_id
where b.n_id is null
posted @ 2012-01-04 17:25 shunliy 阅读(170) 评论(0) 收藏 举报
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。
