Lead function error

[Neha11]

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

[#2 · Accepted solution]

@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

[#3]

Hi,
@olafhelper, thanks for the reply, I understood the concept