Select between different ranges ?

Register Here Forum Rules

The Database Forum

You are currently viewing our The Database Forum as a guest. Please register to participate.

Reply

Link Back Thread Tools Search this Thread

Select between different ranges ?

09-14-2006, 10:04 AM	#1 (permalink) Select between different ranges ?
tomcat_fo Ultra Talker Posts: 275 Trades: 0 Talkupation:	I want to select ID's between to ranges, but it will only work if i drop the last BETWEEN part, but then i don't get all the ID's i need - hope someone can help select * from bolkar where id BETWEEN 30 and 32, where id BETWEEN 36 and 38

Register now for full access!

09-14-2006, 12:21 PM	#2 (permalink) Re: Select between different ranges ?
CouponGuy Extreme Talker Posts: 246 Trades: 3 Talkupation:	Instead of the comma, use OR. Code: select * from bolkar where id BETWEEN 30 and 32 OR id BETWEEN 36 and 38 __________________ *Please login or register to view this content. Registration is FREE* \| *Please login or register to view this content. Registration is FREE*

09-14-2006, 03:45 PM	#3 (permalink) Re: Select between different ranges ?
tomcat_fo Ultra Talker Posts: 275 Trades: 0 Talkupation:	Thanks that worked ! Last edited by tomcat_fo; 09-14-2006 at 03:46 PM..

Reply

« Reply to Select between different ranges ?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off Forum Rules

Feeds: RSS JS XML

Feeds for this forum: RSS JS XML

Page generated in 0.29033 seconds with 12 queries