删除重复行,该如何解决

删除重复行
表a
groupnum B
1 11
1 11
1 10
2 11 
2 20
2 20
2 11
2 15
3 23
3 23
3 15
3 6
3 6
3 6
...
...删除每组（groupnum）里有重复的行只保留一条

[解决办法]

SQL code

--sql2000等高手来,我来个一通俗的select distinct * into #tmp from adelete from ainsert into a select * from #tmpdrop table #tmp--sql 2005delete from afrom (select row_number() over(partition by groupnum,B order by groupnum,B ) n,* from a) as awhere n!=1