MS SQL

lower and upper limit problem

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Aug 2007

Posts: 33

Reputation: ansari.wajid is an unknown quantity at this point

Solved Threads: 0

ansari.wajid ansari.wajid is offline

Offline

Light Poster

lower and upper limit problem

Jul 28th, 2008

I have a table with 3 columns as follows:

lower upper id
12 20 100
100 150 200

I want to select range of numbers based on lower and upper column.
For example I want to display numbers between 12 to 20 or from 100 to 150.
How to do it. thanks in advance.

•

Join Date: Jan 2007

Posts: 22

Reputation: RipperJT is an unknown quantity at this point

Solved Threads: 3

RipperJT

Offline

Newbie Poster

Re: lower and upper limit problem

Jul 29th, 2008

Hi, you can use math comparison operators to select from a range of values, you can add an OR to the statement below to select from an additional range.

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
SELECT
*
FROM
TableName
WHERE 
([lower] >= 12
 AND 
[upper] <= 20)
OR
([lower] >= 100
 AND 
[upper] <= 150)
SELECT
*
FROM
TableName
WHERE 
([lower] >= 12
 AND 
[upper] <= 20)
OR
([lower] >= 100
 AND 
[upper] <= 150)