Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help with a SQL query
select 'a' as ATTRIBUT , count(*) as no from table1 where a is not null
UNION
select 'b' as ATTRIBUT, count(*) as no from table1 where b is not null
UNION
select 'c' as ATTRIBUT, count(*) as no from table1 where c is not null
"Anders Windelhed" <anders_at_underlandstudios.com> wrote in message
news:txqga.30193$oe.93724_at_amstwist00...
> I need help with a SQL query...
>
> I have three queries:
>
> (select 'a' as ATTRIBUT , count(*) as no from table1 where a is not null)
>
> (select 'b' as ATTRIBUT, count(*) as no from table1 where b is not null)
>
> (select 'c' as ATTRIBUT, count(*) as no from table1 where c is not null)
>
> the results from these queries looks like this
>
> attribut no
> a 34
>
> and so on...
>
> I would like to combine into one result table like this
>
> attribut no
> a 34
> b 334
> c 23
>
> I know that it would be much easier to create a query that gives the
result
> like this
>
> a b c
> 34 334 23
>
> but that won't solve my problem =(
>
> Any suggestions?
>
> Best regards
>
> Anders
>
>
Received on Wed Mar 26 2003 - 18:51:34 CST