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

A
Counts rows
B
Assigns a rank to rows within a partition
C
Sorts data
D
Filters data
Solution:

The RANK() function assigns a rank to each row within a partition of a result set, useful for ordered data.

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!