With Denali's CTP 3 release , we have more analytical functions out of which I am interested in two:
I understood that
FIRST_VALUE returns first value based on partition and order by clause while
Last_Value returns last value based on partition and order by clause.
But in what practical situation they will be useful? A sample real time situation will help me understand this.