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
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.
So:
Where (rank/max(rank)>.7)