BUG：LEAD function returns imperfect result even just support OFFSET 1

jerryldh · May 10, 2019, 6:08am

LEAD function returns imperfect result even just support OFFSET 1

balaji.ramaswamy · May 10, 2019, 6:41am

Can you please send us an example

Topic		Replies	Views
Why LEAD function params "offset" just support a value of 1?	2	279	December 12, 2023
What limits Dremio "Lead" only support offset 1？	3	1094	May 8, 2019
LEAD Function Not Working	0	1234	August 14, 2020
In certain situations, the use of the LEAD or LAG functions within the ORDER BY clause is not allowed	0	401	December 27, 2023
Weird behaviour of lead() inside and outside CTE	3	160	October 1, 2024