DELETE TOP(LIMIT) ORDER

정렬 후 몇개만 삭제 시

WITH T
     AS (SELECT TOP 3 *
         FROM   Table1
         ORDER  BY id DESC)
DELETE FROM T

몇개만 삭제

DELETE TOP(1) FROM Table1