Re: Multiple SQL queries in one Report

From: Ethel Aardvark <bigjobbies_at_hotmail.com>
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

Original text of this message