一句SQL去掉重复数据

with aaa(no, name,id) as 
 (
 SELECT no,name,ROW_NUMBER() OVER(ORDER BY no)id FROM c
 )
 select * from aaa where id in (select min(id) from aaa group by no)

如果表中有标识列：

with aaa(no, name,id) as 
 (
 SELECT no,name,id FROM c
 )
 select * from aaa where id in (select min(id) from aaa group by no)