sql去重

--完全相同的数据去掉重复
select id,orderId from (
select row_number() over(order by id) rowId,* from v_order) as tt where rowId in
(
select min(rowId) from (select row_number() over(order by id) rowId,* from v_order) bb 
    group by id having count(id)>=1
)