Which of the following new analytic functions in SQL Server 2012 accesses data from a subsequent row in the same result set without the use of a self-join and provides access to a row at a given physical offset that follows the current row

 Posted by Bandi on 11/30/2013 | Category: Sql Server Interview questions | Views: 5969 | Points: 40
Select from following answers:
  1. LAST_VALUE
  2. FIRST_VALUE
  3. LEAD
  4. LAG
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response