[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

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
0
TrialUser
Asked:
TrialUser
  • 2
2 Solutions
 
Aaron TomoskyTechnology 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 TomoskyTechnology 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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now