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.
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 |
|
|
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" |
|
|
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 |
|
|
expert
Starting Member
4 Posts |
Posted - 2011-09-17 : 11:36:06
|
This link helps to understand RANK functions with sample exampleshttp://www.besttechtools.com/SQLArticles.aspx?ID=Rank |
|
|
|
|
|