What does PERCENT_RANK() return for the first row in a partition ordered by salary ASC?

SQL Data Analyst Hard

SQL Data Analyst — Hard

What does PERCENT_RANK() return for the first row in a partition ordered by salary ASC?

Key points

  • The first row in a partition has a PERCENT_RANK() of 0.0
  • PERCENT_RANK() is based on the order of rows in a partition
  • The function calculates the percentage of rows that are less than or equal to the current row

Ready to go further?

Start full exam Practice more questions

Related questions