Question

The ranking functions make it easy to include a column in a result set that provides the sequential ranking number of each row within a ___________________________.

a. clause
b. partition
c. subquery
d. function

Answer 1

b. partition

Step-by-step explanation:

The ranking functions make it easy to include a column in a result set that provides the sequential ranking number of each row within a partition. This is done as a subset of the built in functions that exist within the SQL Server. If the partition does not exists it can be the full result set. The order of the ranking within the partition is defined by the order clause of OVER.