I have this table: ID Date —————– 1 1/1/2019 1 1/15/2019 Expected output: ID DATE LEAD_DATE ————————- 1 1/1/2019 1/14/2019 1 1/15/2019 SYSDATE …
Tag: case-expression
Conditional Date Comparison and Assignment using Case expression in Oracle SQL
I am new to the site and SQL. I need some help with a case expression. The requirement is as follows: I have a table T1 with two date columns – eff and disc; A second table T2 with 2 date columns -…