Other analytic functions aren't permitted ... For more information, see OVER Clause (Transact-SQL). The following example uses FIRST_VALUE to return the name of the product that is the least expensive ...

/*Problem with last value function is that it doen't look for the data in all rows at once it ...