How to use RowNumber()

hi

row_number() returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.

In your case,

it returns the sequential number of a row within a partition of studentID,FirstName,HealthnsuranceNumber, with order by FirstName

Refer:

http://ift.tt/1wvE66m

http://ift.tt/1tlnpg4

Thanks

Saravana Kumar C