Deleting top 3 from a select [modified]

[Dio22]

I'm trying to order a table by a datetime column (ASC) , then delete the top 3 rows. Help out the n00b. Here's what doesn't work.. DELETE TOP(3) FROM Table ORDER BY DateTime ASC DELETE TOP(3) FROM Table WHERE (SELECT * FROM Table ORDER BY DateTime ASC) i've tried hundreds of other combinations.. Thanks guys/gals.

modified on Wednesday, February 13, 2008 1:58 PM

[Dio22]

Nevermind, figured it out... Thanks all! :) DELETE FROM TableName WHERE (DateTimeCol IN (SELECT TOP (3) DateTimeCol FROM TableName AS TableName_1 ORDER BY DateTimeCol))