delete from xxxxx where id in (select id from (Select * From xxxxx Where appid In (Select appid From xxxxx Group By appid Having Count(*)>1)) as a where uid!=xxx)
delete from xxxxx where id in (select id from (Select * From xxxxx Where appid In (Select appid From xxxxx Group By appid Having Count(*)>1)) as a where uid!=xxx)