tags:

views:

38

answers:

2

What's the difference between a primary key and an RRN?

A: 

A Primary key identifies a row in a table.

An RRN (I presume you mean Relative Record number) also identifies a row by position in a subset (ie. a query result).

I've found it useful if you need to extrapolate a sequential order for a set of records not related to the primary key.

BigChrisDiD
asdfsd fd fsdfsdfsd fsdf sdfsd fsdfsd oops
Anil
+2  A: 
mjv