KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
The problem: I have a table that records data rows in foo . Each time the row is updated, a new row is inserted along with a revision number. The table looks like: id rev field 1 1 test1 2 1 fsdfs 3 1 jfds 1 2 test2 Note: the last record is a newer version of the first row. Is there an efficient way to query for the latest version of a record and for a specific version of a record? For instance, a query for rev=2 would return the 2, 3 and 4th row (not the replaced 1st row though) while a query for rev=1 yields those rows with rev <= 1 and in case of duplicated ids, the one with the higher revision number is chosen (record: 1, 2, 3). I would not prefer to return the result in an iterative way.
Tags (comma-separated)
Save Edits
Cancel