What is the formula upon which the Percent_Rank function works?

 Posted by Rajnilari2015 on 10/24/2015 | Category: Sql Server Interview questions | Views: 228 | Points: 40
Select from following answers:
  1. Percent_Rank = (R -1)/(N-1) where R => The row whose rank needs to be found, N => Total number of rows or records.
  2. Percent_Rank = (R +1)/(N-1) where R => The row whose rank needs to be found, N => Total number of rows or records.
  3. Percent_Rank = (R+1)/(N+1) where R => The row whose rank needs to be found, N => Total number of rows or records.
  4. Percent_Rank = (N-1)/(R-1) where R => The row whose rank needs to be found, N => Total number of rows or records.
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response