thanks Charles for the explanation...
I think Dense_Rank option answer should also be awarded points as it was not specified anywhere regarding this..
I select DENSE_RANK as it leaves no gaps in rank as RANK() do..
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/