Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help with multiple BETWEEN statements
thanks to those for correcting me:
however, when there is only 1 between statement the query comes back quickly.
when there are multiple OR clauses, the query just hangs and eats up system resources. What is happening?
SELECT A from table1
> where rate = 'abc'
> and code between '0100' and '0199'
> OR code between '4000' and '4499'
thanks again.
hlngus_at_hotmail.com (Yvonne G) wrote in message news:<d999b872.0301120842.66c00282_at_posting.google.com>...
> Can someone provide an assist with compound BETWEEN syntax?
>
> I want to enforce the following:
>
> SELECT A from table1
> where rate = 'abc'
> and code between '0100' and '0199'
> and code between '4000' and '4499'
> and code between '7000' and '7999'
> and code between '9000' and '9499'
> etc, etc.
>
> What is the proper syntax?
>
> Thanks.
Received on Sun Jan 12 2003 - 23:04:14 CST