Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What is the range of values return by Percent_Rank function?
on 10/24/2015 | Category:
Sql Server Interview questions
| Views: 208 |
Select from following answers:
Between 0 to 1 inclusive
Between -1 to +1 inclusive
Between -1 to 0 inclusive
Between 0 to 10 inclusive
The range of values return by this function is between 0 to 1 inclusive. The return data type is always a positive number.
e.g. We have a set with 100 elements. We need to find the relative rank of the 19th row.
Percent_Rank = (19-1)/(100-1) = 0.1818181818181818
Show Correct Answer
Many Interviews |
< Previous :
What is Cume_Dist function?
Next > :
What is the formula upon which the Percent_Rank fu ...
Comments or Responses
Login to post response
More Interview Questions by Rajnilari2015
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?
What is First_Value function in DENALI?
Explain the syntax First_Value(expression [IGNORE NULLS]) Over( [ ...
What is true about the First_Value function in DENALI?
What is LAG function in DENALI?
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?