Getting error when i run below stmt ... Plzz help on this , if it wont work i need to write update separately to update null recs i want to avoid it...
coalesec((min(start_dt) over(partition by a_id, b_id order by start_dt asc rows between 1 following and 1 following ))-1,'9999-09-09') as end_dt
error msg :: expected something between '(' and '('. [SQL State=42000, DB Errorcode=3706]
it's coalesce instead of coalesec :-)