Select range from sql database where a particular number belongs

Question

1.00/5 (1 vote)

See more:

I am storing ranges in sql database like following,

Start     End        Percentage
-----     ----      -------------
10         20          1
500        860         5
1000       2500        10

the above shown is the database design

Now the question is,

When I pass 15,then I need to get the percenatge as 1,
means

find the range where 15 occurs and get the percentage of that range

here 15 exists between 10 and 20 and corresponding percentage is 1.

Any help will be gratefull

Thanks

Posted 13-Oct-13 19:46pm

kishore Rajendran

Add a Solution

Comments

Thanks7872 14-Oct-13 1:49am

And? Where is the code you have tried? Post it and also mention why its not working or whats the problem with that code?

JoCodes 14-Oct-13 2:03am

"find the range where 15 occurs and get the percentage of that range
here 15 exists between 10 and 20 and corresponding percentage is 1" ?? not clear at all

kishore Rajendran 14-Oct-13 2:09am

I will pass 15, so I have find the range where this 15 occurs, here it is 10 and 20
thats all

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2013-10-13T19:53:00

Solution 1

Try:

SELECT percentage WHERE value BETWEEN [Start] AND [End]

Posted 13-Oct-13 19:53pm

OriginalGriff

Comments

kishore Rajendran 14-Oct-13 1:55am

but I have only one value to pass,that is 15

OriginalGriff 14-Oct-13 2:02am

So replace the word "value" withe value "15"