SQLite - Window function and Rank to detect duplicates - also using automatic ID and TimeStamps

SQLite - Window function and Rank to detect duplicates - also using automatic ID and TimeStamps
https://forum.knime.com/t/conceptual-question-keeping-history-of-updated-values-in-sqlite-store-as-separate-table/63891/2?u=mlauber71

External resources

• Play around with SQLite and Date and Time functions
• use H2 to produce a Position / Rank number within a group variable (window functions)
• HUB: SQLite - Window function and Rank to detect duplicates - also using automatic ID and TimeStamps
• forum entry
• School of duplicates - and how to deal with them