SQL Get Latest Unique Rows
- by Simpleton
I have a log table, each row representing an object logging its state. Each object has a unique, unchanging GUID. There are multiple objects logging their states, so there will be thousands of entries, with objects continually inserting new logs. Everytime an object checks in, it is via an INSERT.
I have the PrimaryKey, GUID, ObjectState, and…