On Fri, May 29, 2015 at 12:48 PM, Stephen Cook <sclists@gmail.com> wrote:
Use UNION ALL:
select * from table where number * 3 between start_value1 and end_value2 UNION ALL select * from table where number * 3 between start_value2 and end_value2 UNION ALL select * from table where number * 3 between start_value3 and end_value3;
SELECT * FROM table
WHERE number * 3 BETWEEN start_value1 AND end_value1
OR number * 3 BETWEEN start_value2 AND end_value2
OR number * 3 BETWEEN start_value3 AND end_value3
;
-- Stephen
On 5/29/2015 12:32 PM, Arup Rakshit wrote:
Hi,
Can I do the below 3 queries in a single query ?
select * from table where number * 3 between start_value1 and end_value2; select * from table where number * 3 between start_value2 and end_value2; select * from table where number * 3 between start_value3 and end_value3;