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
沒有留言:
張貼留言