Answer 1

Which type op sql do you use ?

Have a look at this link.

http://www.besttechtools.com/articles/article/sql-rank-functions

Rank
Returns the rank of each row in the result set of partitioned column.

DENSE_RANK()
This is same as RANK() function. Only difference is returns rank without gaps.