'SQL Timestamp query: Check if one timestamp is earlier than another
For CallLogTable....I need to write a query which finds scenarios where the created_ts timestamp of one row has an earlier timestamp than the updated_ts timestamp of the row immediately BEFORE. Rows 1 and 2 are an example (The created_ts of row 2 is earlier than the updated_ts of row 1). I have seen use of Rownums but not sure how to apply it here. Many thanks in advance for your help!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|