I had the same thought as you but I think you would want to use row_number not rank. Here is a good example of the difference between rank, and row_number.

http://stackoverflow.com/questions/7747327/sql-rank-versus-row-number