Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Suppose we have a set with 39 elements. We need to find the relative rank of the 9th row. What will be the value of Percent_Rank function?
on 10/24/2015 | Category:
Sql Server Interview questions
| Views: 223 |
Select from following answers:
Percent_Rank = (R -1)/(N-1)
R => The row whose rank needs to be found
N => Total number of rows or records.
As per the question, we have
R =9 , N = 39
So, Percent_Rank = (R -1)/(N-1) = (8)/(38) = 0.2105263157894737
Show Correct Answer
Many Interviews |
< Previous :
What is true about Percentile_Cont function?
Next > :
Suppose we have a set with 35 elements. We need to ...
Comments or Responses
Login to post response
More Interview Questions by Rajnilari2015
Suppose we have a set with 35 elements. We need to find the cumulative ...
What is the formula for Cume_Dist function?
What is Cume_Dist function?
What is the range of values return by Percent_Rank function?
What is the formula upon which the Percent_Rank function works?
What is Percent_Rank function?
What is/are true about the Last_Value function in DENALI?
What is Last_Value function?
Latest Interview Questions
Which of the following is a server-scoped securable?
The Clients table includes the following columns ClientId Spouse Ki ...
You would include a HAVING clause in a query to
How can you prevent user to enter duplicate value into column while cr ...
What is AngularJS?
What is the role of implementation phase in STLC(Software Testing Life ...
What is test plan ?
What is test planning?