'2018/07/04'에 해당되는 글 1건

  1. 2018.07.04 DELETE TOP(LIMIT) ORDER
2018.07.04 16:35

DELETE TOP(LIMIT) ORDER

정렬 후 몇개만 삭제 시
WITH T
     AS (SELECT TOP 3 *
         FROM   Table1
         ORDER  BY id DESC)
DELETE FROM T
몇개만 삭제
DELETE TOP(1) FROM Table1
Trackback 0 Comment 0