hard20 pts · first answer countswindow-functionssqldata-cleaning

Last known value with IGNORE NULLS

In Snowflake, which expression fills each NULL reading with the latest earlier non-NULL reading?

A.FIRST_VALUE(reading) IGNORE NULLS OVER (ORDER BY ts ROWS UNBOUNDED PRECEDING)B.LAG(reading) OVER (ORDER BY ts ROWS UNBOUNDED PRECEDING)C.LAST_VALUE(reading) IGNORE NULLS OVER (ORDER BY ts ROWS UNBOUNDED PRECEDING)D.LAST_VALUE(reading) OVER (ORDER BY ts ROWS UNBOUNDED PRECEDING)

Discussion 0

Join free to post in the discussion.

Last known value with IGNORE NULLS

Discussion 0

Related questions