SQL : select values between multiple ranges

Question

I have a table like the one below...

ID    Price
==== ======
1    1000
2    2000
3    4000
4    5000

Now I need a query to select values between 500 and 1500 And between 2500 and 4500. i.e. like using two between in a single select query...

is it possible?

output should be:

ID    Price
==== ======
1    1000
3    4000

jarlh · Accepted Answer · 2015-03-23 10:27:45Z

11

select id, price
from tablename
where price between 500 and 1500
   or price between 2500 and 4500

answered Mar 23, 2015 at 10:27

jarlh

44.9k8 gold badges52 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

What if the ranges are coming from a table? So it is possible to have dynamic query for multiple ranges?

@Aryo, you can probably do a JOIN and put the conditions in the ON clause. Ask a question and put the link here, and I'll take a look at it.