删除重复数据 删除重复数据: 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