sql去掉重复数据

select top 10 Id,proName,ProPrice from yxs_orderproduct where proname in(select proname from yxs_orderproduct group by proname having count(proname)=1) order by (proPrice*ProNum) desc