정렬 후 몇개만 삭제 시
WITH T
AS (SELECT TOP 3 *
FROM Table1
ORDER BY id DESC)
DELETE FROM T
몇개만 삭제
DELETE TOP(1) FROM Table1
메모장이라 볼만한건 없을 것임~
by 와이즈번
Category
|
WITH T
AS (SELECT TOP 3 *
FROM Table1
ORDER BY id DESC)
DELETE FROM T
DELETE TOP(1) FROM Table1
|
Rss Feed