Hi, thanks for your review.
Yes, the syntax is different, but the idea is same. Oracle like syntax should by supported in future, as Taylor wrote above.
Current syntax for function is LAST_VALUE(arg1, arg2[, arg3]).
arg1 specify column witch will be get data from
arg2 specify column for order these (arg1) values
arg3 optional argument, says Nth row to select (after sort by arg2 column)
Return value is determined by sorting data from arg1 column by column arg2. if is Nth value specified it is returned Nth element from sorted set.
Dataset is regularly selected by WHERE clause.
Is that answer to your question?