SQL LAST_VALUE with IGNORE NULLS option
SQL LAST_VALUE with ROWS BETWEEN clause
SQL LAST_VALUE with ORDER BY clause
SQL LAST_VALUE with PARTITION BY clause
SQL LAST_VALUE vs. SQL FIRST_VALUE