Re: Multiple SQL queries in one Report
Date: 7 Mar 2003 07:07:15 -0800
Message-ID: <1a8fec49.0303070707.7bb4b79c_at_posting.google.com>
How about:
SELECT ALL something, COUNT(1)
FROM somewhere
WHERE something LIKE 'BSC%'
AND somethong between 'BSC01' and 'BSC46' -- or perhaps 'BSC45zzzzz'
GROUP BY something
or
SELECT ALL something, COUNT(1)
FROM somewhere
WHERE
(something LIKE 'BSC%'
AND somethong between 'BSC01' and 'BSC45')
OR something LIKE 'BSC45%'
GROUP BY something
This does assume that you want every thing from 01 to 45 of course...
ETA
vb_bip_at_yahoo.com (wacky) wrote in message news:<8ec7a409.0303060101.55d3bdd8_at_posting.google.com>...
> Hi all,
>
> I have a little problem, and if you have a solution please reply.
>
> In an oracle Report I have 45 simmilar quries that look like this:
>
> SELECT ALL something, COUNT(1)
> FROM somewhere
> WHERE something LIKE 'BSC01%'
> GROUP BY something
>
> Other 44 queries hav values from 'BSC02%' to 'BSC45'.
>
> Now I would like to know is there any way to make only one
> query and the value 'BSC$$%' to receive from some PL/SQL
> or somethin else???
>
> Thanks
Received on Fri Mar 07 2003 - 16:07:15 CET