Q. What does the ROW_NUMBER() function do in SQL?

A
Counts total rows
B
Assigns a unique number to each row
C
Calculates a sum
D
Filters data
Solution:

ROW_NUMBER() assigns a unique sequential number to each row within a partition of a result set.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!