Hello, Need help with below DATE1 DATE2 DATE3 20-Apr-21 1-Jan-21 31-Dec-99 20-Apr-21 1-Jan-21 31-Dec-99 20-Apr-21 1-Jan-21 31-Jan-00 20-Apr-21 1-Jan-21 31-Dec-99 20-Apr-21 1-Jul-19 31-Dec-20 20-Apr-21 1-Jul-19 31-Dec-20 27-Apr-21 1-Jul-19 31-Dec-20 28-Apr-21 1-Jul-19 31-Dec-20 29-Apr-21 1-Jul-19 31-Dec-20 All the three dates were sorted Scenario-1) If DATE1 is not changed, DAT2 is not changed and only DATE3 has changed, I need those rows That means first two rows Scenario 2) Suppose DATE3 doesn't exists Now I need to get only first 4 rows of DATE1 and DATE2, as there is a change starting in DATE2, in row5 Thanks in advance!
... View more