Delete n number of rows at a time
Posted on 2014-03-11
I need to delete 1000 records at a time starting from now-1 day,
and I need it for both DB2 and SQLServer.
If it's 13:50 3/11/2014,
I need to delete 1000 records at a time starting from 13:50 3/10/2014
Is there a sql statement that I can (repeatedly) construct and then call repeatedly until it is done?