SQL Server2005中删除重复行

以前写的东西，可以看看思路

/**//*
删除表中重复行的方法
*/
ifexists(select1fromsys.tableswherename='t_dup')
droptablet_dup
go
createtablet_dup(idint,ageint,namevarchar(32))
insertintot_dup
select1,1,'a'
unionallselect1,1,'a'
unionallselect1,1,'a'
unionallselect1,2,'a'
unionallselect1,2,'e'
unionallselect2,3,'b'
unionallselect3,3,'d'
go
select*fromt_dup
go
witht_allas
(selectid,age,name,row_number()over(orderbyid)[num]
fromt_dup),
t_maxas
(selectid,age,name,max(num)num
fromt_all
groupbyid,age,name)
selectid,name,agefromt_allawhereexists(select1fromt_maxwherenum=a.num)

<script type="text/javascript">document.write("<img src=http://counter.csdn.net/pv.aspx?id=24 border=0 width=0 height=0>");</script><script type="text/javascript">LoadFeedbackCount();</script><script language="javascript" type="text/javascript"> ad_width=468; ad_height=60; adcss=2; unionuser=19; tags=''; ad_type='j'; count=2; </script><script type="text/javascript" src="http://tagegg.csdn.net/showads.js" language="javascript"></script><script src="http://tagegg.csdn.net/b.aspx?action=displayad&amp;unionuser=19&amp;unionurl=http%3A%2F%2Fblog.csdn.net%2Fwhbo%2Farchive%2F2008%2F05%2F07%2F2412445.aspx&amp;adcss=2&amp;ad_type=j&amp;width=468&amp;height=60&amp;ad_color=&amp;ad_color_border=&amp;count=2" language="JavaScript1.1" type="text/javascript"></script>