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
No comments:
Post a Comment