按照某字段去重的SQL

oracle按照某字段去重的SQL(一):按照name来去重:

select * from emp e1 where exists(

select name from emp e2 

where e1.name=e2.name 

group by e2.name

having max(e2.rowid)=e1.rowid);

oracle按照某字段去重的SQL(二):按照订单号去重:

select * from xs_order_raw r1 where id in (
select max(id) from xs_order_raw r2 
group by r2.order_num
);