Select from following answers:
Show Correct Answer
- 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
Asked In: Many Interviews |