On Fri, May 29, 2015 at 12:48 PM, Stephen Cook <scli...@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;
>>
>>
>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
My sister opened a computer store in Hawaii. She sells C shells down by the
seashore.
If someone tell you that nothing is impossible:
Ask him to dribble a football.
He's about as useful as a wax frying pan.
10 to the 12th power microphones = 1 Megaphone
Maranatha! <><
John McKown
