'2018/07/04'에 해당되는 글 1건
- 2018.07.04 DELETE TOP(LIMIT) ORDER
2018. 7. 4. 16:35
DELETE TOP(LIMIT) ORDER
2018. 7. 4. 16:35 in 팁&테크/MSSQL
정렬 후 몇개만 삭제 시
WITH T AS (SELECT TOP 3 * FROM Table1 ORDER BY id DESC) DELETE FROM T
몇개만 삭제
DELETE TOP(1) FROM Table1