Tags: containstable, database, fts, microsoft, mysql, oracle, ranking, records, scores, server, sql, term, thetop, toget

how to get the "last" 100 records in FTS

On Database » Microsoft SQL Server

366 words with 0 Comments; publish: Fri, 06 Jun 2008 12:52:00 GMT; (25046.88, « »)

As we all know,we can use the term"top 100" in containstable to get the

top 100 records which have higher ranking scores. however,if i want to

get the last 100 records having lower ranking scores. how can i do

except the way that using top 100 after ordering the records by rank


By the way,can we modify the algorithm of the ranking?

All Comments

Leave a comment...