ID DATE 1 2015-07-23 04:00:02.000 2 2015-07-24 04:00:02.000 3 2015-07-25 04:00:02.000 4 2015-07-26 04:00:02.000 5 2015-07-27 04:00:02.000 6 2015-07-28 04:00:02.000 7 2015-07-29 04:00:02.000 8 2015-07-30 04:00:02.000
DELETE from mytable WHERE id IN (SELECT TOP 2 ID FROM mytable ORDER BY Date ASC)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)