How to limit the number of entries?

Question

SQLite

There is a table for logging records, how to make sure that records older than one month are deleted relative to the last record?

Answer 1

For sampling:

SELECT 
*
FROM logTable
WHERE logTable.date > DATEADD(month, -1, (SELECT MAX(logTable.date) FROM logTable))

For removing:

DELETE
FROM logTable
WHERE logTable.date <= DATEADD(month, -1, (SELECT MAX(logTable.date) FROM logTable))

Answer 2

Create a task that will run a query with the removal of old entries and add it to the task scheduler for daily execution.