Re: count(*) in sql statement
From: <jfr_at_trwlasd.com>
Date: Fri, 10 Jun 1994 09:53:25 GMT
Message-ID: <Cr6E52.D26_at_trwlasd.com>
Date: Fri, 10 Jun 1994 09:53:25 GMT
Message-ID: <Cr6E52.D26_at_trwlasd.com>
Michael Ryan writes
>
> select count ( distinct a.rowid ) a_count,
> count ( distinct b.rowid ) b_count
Just a note of caution. This is invalid ANSI SQL and so it only works in Oracle (and possibly a few other systems with extensions). In ANSI SQL, a distinct may only be applied to a single column in a query.
Jon Rosen Received on Fri Jun 10 1994 - 11:53:25 CEST