inal Message ----
Subject: Query Range
Date: Mon, 08 Dec 2003 11:23:28 -0600
From: Mike Blezien <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Organization: Thunder Rain Internet Publishing
To: MySQL List <[EMAIL PROTECTED]>
Hello,
been trying to figure out the correct SQL query
Sorry..
The query should be:
select percentage from table_name where
min >= 500.00 and 500.00 <= max;
database.
Original Message
Subject: Query Range
Date: Mon, 08 Dec 2003 11:23:28 -0600
From: Mike Blezien <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Organizat
Hello,
been trying to figure out the correct SQL query to get
percentage from a table that list a Min, and Max., price
range and the percentage associated to the range.
Here is the current data in the table:
1 0.00 4999.00 13.0
2 5000.00 .00 12.5
3 1.00 14999.00 12.0
4 15000.00 1.00
