Thursday, September 22, 2016

Limiting Deleted Rows by Using TOP



USE AdventureWorks2008R2;
GO
DELETE FROM Purchasing.PurchaseOrderDetail
WHERE PurchaseOrderDetailID IN
   (SELECT TOP 10 PurchaseOrderDetailID 
    FROM Purchasing.PurchaseOrderDetail 
    ORDER BY DueDate ASC);
GO
 
 
------------------------------------
 
 
USE AdventureWorks2008R2;
GO
DELETE TOP (20) 
FROM Purchasing.PurchaseOrderDetail
WHERE DueDate < '20020701';
GO
 

-------------------------


;WITH CTE AS
(
SELECT Top 5*
FROM [PriceMaster_Market]
 ORDER BY creation_Date
)
DELETE FROM CTE