sql - Modify data to reflect another record in same group - Stack Overflow

need to modify the EndDate of the earlier record to the day before the StartDate on the later record so in this example the ... The query will give you the enddate minus one for the next record. SQL> CREATE TABLE t (ID VARCHAR2(10), sd DATE, ed ('01 ...

stackoverflow.com