Which window function divides rows into 4 approximately equal groups?

SQL Data Analyst Medium

SQL Data Analyst — Medium

Which window function divides rows into 4 approximately equal groups?

Key points

  • NTILE(4) divides rows into 4 groups
  • RANK() assigns a rank to each row without dividing into groups
  • PERCENT_RANK() calculates the relative rank of each row
  • CUME_DIST() calculates the cumulative distribution of a value

Ready to go further?

Start full exam Practice more questions

Related questions