Re: How to SELECT the COUNT??

I've done this before as

 SELECT	SUM(DECODE(SAL_TYPE, 'A', 1, 0)) TYPE_A,
	SUM(DECODE(SAL_TYPE, 'B', 1, 0)) TYPE_B
   FROM	EMP

Of course there are other ways.

Ken

Violin wrote:
>
> Hello all,
> I have a select count question.
> If I have a table like this:
>
> EMPNO SAL_TYPE
> --------------------------------
> 00001 A
> 00002 A
> 00003 B
> 00004 A
> 00005 B
> 00006 B
> 00007 A
>
> I want to do a select :
> SELECT COUNT(T1.EMPNO) "TYPE_A",
> COUNT(T2.EMPNO) "TYPE_B"
> FROM EMP T1,EMP T2
> WHERE T1.SAL_TYPE = 'A' and
> T2.SAL_TYPE = 'B';
>
> The result like this:
> TYPE_A TYPE_B
> ---------------------------------
> 4 3
>
> How to do the SELECT COUNT sql?
> Thanks for your tips.
>
> Violin.
> violin.hsiao_at_mail.pouchen.com.tw
Received on Mon Apr 26 1999 - 19:24:38 CDT