Re: pl/sql issue

From: William Robertson <williamr2019_at_googlemail.com>
Date: Sun, 01 Jul 2007 06:37:06 -0700
Message-ID: <1183297026.624585.20250@o61g2000hsh.googlegroups.com>

On Jun 29, 10:09 am, sybrandb <sybra..._at_gmail.com> wrote:
>
> Your statement is
> SELECT 'Total count', COUNT(*)
> FROM USRMGMTUserDetails
> WHERE IsRegistered = 1
> union
> SELECT 'Active users', COUNT(*)
> FROM USRMGMTUserDetails
> WHERE IsActive = 1
> UNION
> SELECT 'Pending registrations', COUNT(*)
> FROM USRMGMTUserDetails
> WHERE IsRegistered = 0
>

Or even:

SELECT COUNT(DECODE(isregistered,1,'#')) AS "Total rows"
     , COUNT(DECODE(isactive,1,'#'))     AS "Active users"
     , COUNT(DECODE(isregistered,0,'#')) AS "Pending registrations"

FROM usrmgmtuserdetails;

Or perhaps, if these are numeric indicator columns that can only ever be 0 or 1:

SELECT SUM(isregistered) AS "Total rows"

     , SUM(isactive)     AS "Active users"
     , COUNT(*) - SUM(isregistered) AS "Pending registrations"

FROM usrmgmtuserdetails; Received on Sun Jul 01 2007 - 08:37:06 CDT