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?

Improve company productivity with a Business Account.Sign Up

x
Advertise Here
 
Aaron TomoskyConnect With a Mentor SD-WAN SimplifiedCommented:
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 SD-WAN SimplifiedCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.