hard20 pts · first answer countswindow-functionssql

LAG default vs COALESCE

Row 1 has no previous row. Row 5's previous row exists but its value is NULL. What does LAG(x, 1, 0) return on rows 1 and 5?

A.NULL on row 1, 0 on row 5B.0 on both rowsC.NULL on both rowsD.0 on row 1, NULL on row 5

Discussion 0

Join free to post in the discussion.