每日一SQL-刪除重複資料 - 我的Coding之路- 點部落

re: 每日一SQL-刪除重複資料 請問我直接在sql server 2008 上寫下如您所說的 with temp as(SELECT *,ROW_NUMBER() over(order by TC001,TC002,TD003,TD017) AS rnk FROM [purchase].[dbo].[PURS]where TA001='3121' and TB002='20110215001' and TB003 ...

www.dotblogs.com.tw