...
| Catchment | HID1 | HID2 | Rule Name | Rule Value | Created At |
| A30B31 | h3 | h5 | nid | nid1 | t.. |
| A30B31C32 | h3 | h5 | nid | nid1 | t.. |
| A40B41 | h4 | h5 | phone # | ph1 | t.. |
| A40B41C42 | h4 | h5 | phone # | ph1 | t.. |
| A40B41 | h4 | h5 | nid | nid1 | t.. |
| A40B41C42 | h4 | h5 | nid | nid1 | t.. |
| A50B51 | h5 | h3 | nid | nid1 | t.. |
| A50B51C52 | h5 | h3 | nid | nid1 | t.. |
| A50B51 | h5 | h4 | phone # | ph1 | t.. |
| A50B51C52 | h5 | h4 | phone # | nid1 | t.. |
Find duplicates by catchment:
select * from dedup where catchment = 102030.
Then sort the result by timeuuid (time component only) in-memory and return.