Previous row date column update, based on current row date
Hi,I have single record with assigned_date as '2018-06-18 10:35:01.163' and completed_date as 'NULL'.
My requirement is:
When another new record gets inserted, assigned_date is '2018-06-18 11:35:01.163' and completed_date is 'NULL'.
I want a sql query where the immediate previous record completed_date should be update with newly inserted assigned_date. i.e previous record completed date should become as '2018-06-18 11:35:01.163'.
Regards,
Ayesha