Purpose Returns the first value or last value in an ordered set of values. Type ANSI SQL:2011 window function. Syntax