Delete records based on a rule
I have a table (History) that is tracking changes of another table (Projects). I want to only keep the 10 most current history records for a project. Is there a way to do this?
Forum Discussion
Going with blanket SQL statement to keep 30 days of history
DELETE FROM History
WHERE Date_Created <= '30 days ago';
Note: SQL statement given more of a template ;)
DELETE FROM History
WHERE Date_Created <= '30 days ago';
Note: SQL statement given more of a template ;)