Re: row_number() over(Partition by) Throw Error with Null Input.

Thanks Gopal .. That should help Thanks Karthik > On Nov 10, 2014, at 0:49, Gopal V wrote: > >> On 11/9/14, 10:16 PM, karthik Srivasthava wrote: >> >> select row_number() over (PARTITION BY >> country,state,department,branch_name) from Employee_details; >> select count(*) over (PARTITION BY

Re: row_number() over(Partition by) Throw Error with Null Input.

On 11/9/14, 10:16 PM, karthik Srivasthava wrote: select row_number() over (PARTITION BY country,state,department,branch_name) from Employee_details; select count(*) over (PARTITION BY country,state,department,branch_name) from Employee_details; You haven't posted the entire back trace, so I'm

row_number() over(Partition by) Throw Error with Null Input.

Hi, select row_number() over (PARTITION BY country,state,department,branch_name) from Employee_details; select count(*) over (PARTITION BY country,state,department,branch_name) from Employee_details; These queries throw Error when Employee_details table has zero rows They work great if the tabl