Forum Discussion
Solved
Lead function error
Hi, I have lead function after on clause as one of the conditions in join Gives an error to me as "misuse of window function lead()" Pls help
Neha11 , a Windows function like LEAD is a post operation, you can not use it in a JOIN condition or in a WHERE clause, only in the SELECT clause.
One way round is to use a CTE = Common Table Expression to re-use the query result.
Olaf
Neha11 , a Windows function like LEAD is a post operation, you can not use it in a JOIN condition or in a WHERE clause, only in the SELECT clause.
One way round is to use a CTE = Common Table Expression to re-use the query result.
Olaf
