Select from following answers:- It is an Aggregate function introduced from SQL Server 2012.Within a group of rows,it calculates the relative rank of a row.
- It is an Analytic function introduced from SQL Server 2012.Within a group of rows,it calculates the relative rank of a row.
- It is both Aggregate and Analytic function introduced from SQL Server 2012.Within a group of rows,it calculates the relative rank of a row.
- It is both Aggregate and Analytic function introduced from SQL Server 2012.Within a group of rows,it calculates the absolute rank of a row.
- All Above
It is both Aggregate and Analytic function introduced from SQL Server 2012.Within a group of rows,it calculates the relative rank of a row.The range of values return by this function is between 0 to 1.The return value from this function is always NUMBER.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator