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
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).