How is it possible to make the previous record zero.
Code: Select all
Col1 Col2 Min_Date Max_Date Code COunt
123 456 2004-01-01 2004-12-10 30 1
123 456 2004-12-11 2004-12-10 30 1
Result :
Code: Select all
Col1 Col2 Min_Date Max_Date Code COunt
123 456 2004-01-01 2004-12-10 30 0
123 456 2004-12-11 2004-12-10 30 1