Select from following answers:- It acts both as Aggregate and analytic function.
- 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.
- 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.
- Introduced in SQL Server 2012
- All Above

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.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.It is both as Aggregate and analytic function.Introduced in DENALI
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator