sql server freetextable rank

I am doing a search using SQL server freetextable. I would like to cut off the result set, where the ranking drops down steeply. How can I achieve this. For exg. if I do a search and the rank goes like this :
453
452
450
449
300
280
270

Then I would like to show results with rank > 300. Please help. thanks
TrialUserAsked:
Who is Participating?
 
Aaron TomoskyConnect With a Mentor Technology ConsultantCommented:
maybe a percent of the max?
So:
Where (rank/max(rank)>.7)
0
 
TrialUserAuthor Commented:
that will only give a percent with respect to the max(rank). i want to know where the percentage drop is steep. thanks
0
 
Aaron TomoskyConnect With a Mentor Technology ConsultantCommented:
To compare to the next one in order is much harder than comparing to the max. You basically have to put the result set into a table, take the top value from that table, compare it to the next top, save the difference. Rbar (row by agonizing row). Much easier to do this in whatever programming language your app is in.

0
All Courses

From novice to tech pro — start learning today.