[SQL]刪除無主Key重複資料的第一筆

因發現來源端資料有重複，故需刪除重複，SQL如下

WITH  q AS
        (
        SELECT TOP 1 *
        FROM   test where id = '123' and week = 2 and section = '06'
        )
DELETE
FROM    q