info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
multiple "count distinct" in one group by select?
0 views
Skip to first unread message
Daniel Rabe
Mar 14, 2000, 3:00:00 AM3/14/00
to
create table joe ( x int, y int, z int )
go
select x, count(y), count(z) from joe group by x
go
select x, count(distinct y), count(distinct z) from joe group by x
go
go
select x, count(y), count(z) from joe group by x
go
select x, count(distinct y), count(distinct z) from joe group by x
go
The last select statement fails on ASA 6.0 on Windows NT. Why? (For what
it's worth, it works in Oracle 8 and SQL Server 7).
0 new messages