※ 刪除前,先用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
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