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-0

Database
Enthusiast

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-0

Hi ,

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]

Thanks,

Rajendra Reddy

1 REPLY
Senior Apprentice

Re: 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-0

Hi Rajendra,

it's coalesce instead of coalesec :-)