Which of the following function is a analytic window function ?
A. LAG
B. LEAD
C. FIRST_VALUE
D. None of the mentioned
Answer:A
Which of the following function is a analytic window function ?
A. LAG B. LEAD C. FIRST_VALUE D. None of the mentioned
Explanation: There are 8 analytic window function in SQL Server 2012.