PurposeReturns the first value or last value in an ordered set of values. TypeANSI SQL:2011 window function. Syntax