LAST_VALUE

FIRST_VALUE and LAST_VALUE functions

About window functions