The Leaders is a view which holds score for a contest for particular user (UserID - ContestID - Unique).... 🙂

I used ROW_NUMBER() in main query to get the rank of...

Hey thanks to everyone for responding for my problem.

john.arnott - Thanks for your solution.. after i digged into google for solution i myself found the solution using RowNumber (Sorry i...