What is true about Percentile_Cont function?

 Posted by Rajnilari2015 on 10/24/2015 | Category: Sql Server Interview questions | Views: 1542 | Points: 40
Select from following answers:
  1. It acts both as Aggregate and analytic function.
  2. An inverse distribution function which takes a percentile value and a sort specification and returns an interpolated value that would fall into that percentile value with respect to the sort specification.
  3. It accepts any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype as it's argument and returns the same datatype as the numeric datatype of the argument.
  4. Introduced in SQL Server 2012
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response