A admin Administrator Staff member Aug 21, 2008 #1 how do I limit a table to let's say 1000 rows? What's the DELETE statement to delete all rows except the 1000 most recent ones? I don't want to delete by date, I just want to delete anything that goes over 1000 rows. thanx Philippo
how do I limit a table to let's say 1000 rows? What's the DELETE statement to delete all rows except the 1000 most recent ones? I don't want to delete by date, I just want to delete anything that goes over 1000 rows. thanx Philippo
