Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 RANKING in Sql Query

Author  Topic 

chava_sree
Yak Posting Veteran

56 Posts

Posted - 2008-07-24 : 11:51:51
Does anybody know how to get Ranking for SQL QUERY for a Resultset.

i need to rank my search Results based on the relevant searches.
(ps: I am not using fullText as it doesn't work for me here).

can anybody pls.suggest a solution for this.

thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-24 : 11:53:07
have a look at RANK and DENSE_RANK windowing functions in books online
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-24 : 11:53:26
There are a number of ranking functions available in SQL Server 2005.

ROW_NUMBER(), RANK(), DENSE_RANK() and NTILE().

Read all about them in Books Online.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-24 : 11:54:50
http://msmvps.com/blogs/martinpoon/archive/2006/09/22/SQL-Server-2005-ranking-functions-_2D00_-RANK_280029002C00_-DENSE_5F00_RANK_280029002C00_-NTILE_28002900_-.aspx
Go to Top of Page

expert
Starting Member

4 Posts

Posted - 2011-09-17 : 11:36:06
This link helps to understand RANK functions with sample examples
http://www.besttechtools.com/SQLArticles.aspx?ID=Rank
Go to Top of Page
   

- Advertisement -