Code block

Google Code Prettify + AD Sense

2016年10月18日 星期二

刪除資料表內完全相同的資料的其中一筆

使用CTE,並且用ROW_NUMBER,建立一個ROWID,再以ROWID刪除
※ 刪除前,先用SELECT確認一下


WITH Del_Temp AS (
SELECT *,ROW_NUMBER() OVER (ORDER BY COL_A) AS ROWID
FROM [dbo].[TABLE] where COL_A = 'RECORD_ID'
)

SELECT * FROM Del_Temp WHERE ROWID = 1
--DELETE Del_Temp WHERE ROWID = 2

1 則留言:

  1. Best Casino Site in Canada with Jackpot City Slots
    Jackpot luckyclub.live City Slots is one of the best online gambling sites in Canada. You can find plenty of exciting casino games like blackjack, roulette, keno,

    回覆刪除