;with cte as (SELECT id,Date,sno,bin,batch,DATEDIFF(second,LAG(Date,1) OVER(ORDER BY Date),Date) AS interval FROM bin1_final) update cte set gap_int = intervalI assume that Id is the primary key (unique) in your table.
> SELECT id,Date,sno,bin,batch,DATEDIFF(second,LAG(Date,1) OVER(ORDER BY Date),Date) AS alias > FROM bin1_final >>
> update bin1_final set gap_int=( > SELECT DATEDIFF(second,LAG(Date,1) OVER(ORDER BY Date),Date) as ddif > FROM bin1_final) >>