What does PERCENT_RANK() return for the highest-ranked row in a window?

SQL Data Analyst Hard

SQL Data Analyst — Hard

What does PERCENT_RANK() return for the highest-ranked row in a window?

Key points

  • PERCENT_RANK() returns a value between 0.0 and 1.0
  • The highest-ranked row in a window has a PERCENT_RANK() of 0.0
  • This function is useful for analyzing the relative position of a row in a dataset

Ready to go further?

Start full exam Practice more questions

Related questions