马上下班，求一个问题先

[Kingofcode]

一个表有多列，现在问题是如何删除某2列相同的重复记录，但要求保留一条，
例如

表A (id,no,name,remark)
1,01,name1,rrr
2,01,name1,aaa
3,02,name2,aaa
4,01,name1,ccc
5,02,name2,ddd

想要的结果为
1,01,name1,rrr
3,02,name2,aaa

[道素]

DELETE FROM a  WHERE not EXISTS ( SELECT 0 FROM (
SELECT ROW_NUMBER()OVER(PARTITION BY no ORDER BY id) AS rowno, * FROM a ) AS t WHERE t.id=a.id AND t.rowno=1
)