Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 29 of 118
Free Preview · 118 of 392 · questions 1–118 of 392 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
- row_number() assigns 1, 2, 3, ... in order, with no gaps or ties. rank() assigns the same number to ties and leaves gaps. dense_rank() ties but without gaps. ntile(n) buckets rows into n groups.