What is/are true about the Last_Value function in DENALI?

 Posted by Rajnilari2015 on 10/24/2015 | Category: Sql Server Interview questions | Views: 1442 | Points: 40
Select from following answers:
  1. It is an analytic function.
  2. It returns the last value from the order set of values.
  3. If the last value in the set is null, then the function returns null until we specify IGNORE NULLS.
  4. If we specify IGNORE NULLS,then Last_Value function returns the first non-nullable value else it returns all null values
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response