CASE WHEN LEAD({itemid},1,0) OVER (ORDER BY {itemid}) as NEXT_TR,LAG({itemid},1,0) OVER (ORDER BY {itemid}) AS PREV_TR WHERE PREV_TR = NEXT_TR THEN 1 ELSE 0 END