LAST_VALUE comes in the category of :
A. Ranking window function
B. Associate window function
C. Analytic window functions
D. All of the mentioned
Answer:A
LAST_VALUE comes in the category of :
A. Ranking window function B. Associate window function C. Analytic window functions D. All of the mentioned
Explanation:The analytic window functions are new for SQL Server 2012.