how to use rank in Sql Server

RANK:

Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.

Kindly refer the below links, Hope this will solve your problem.

http://blog.sqlauthority.com/2007/10/09/sql-server-2005-sample-example-of-ranking-functions-row_number-rank-dense_rank-ntile/

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

http://stackoverflow.com/questions/12739208/how-to-use-rank-in-sql-server

http://www.codeproject.com/Tips/586876/Use-SQL-Servers-Ranking-Functions-Wisely

http://www.sqlservercurry.com/2009/04/rank-vs-denserank-with-example-using.html

Let me know for any thing more....

If your problem solved means kindly Accept my answer

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi10y ago
Hi,

Go through below link-
http://www.besttechtools.com/articles/article/sql-rank-functions
Arul R10y ago
RANK:
Returns the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question.

Kindly refer the below links, Hope this will solve your problem.

http://blog.sqlauthority.com/2007/10/09/sql-server-2005-sample-example-of-ranking-functions-row_number-rank-dense_rank-ntile/

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

http://stackoverflow.com/questions/12739208/how-to-use-rank-in-sql-server

http://www.codeproject.com/Tips/586876/Use-SQL-Servers-Ranking-Functions-Wisely

http://www.sqlservercurry.com/2009/04/rank-vs-denserank-with-example-using.html

Let me know for any thing more....
If your problem solved means kindly Accept my answer