Archives of the TeradataForum
Message Posted: Tue, 30 Jan 2001 @ 19:42:29 GMT
I do not have access to the on-line call logs, can someone do a search for me? I think I have found a problem with count(distinct mycollumn), which returns the wrong result:
select CId, count(distinct PId)
This query produces results roughly 3 times the values of the same query in MSSQLServer 7.0. We have also decomposed the query into separate queries with temp tables and a derived query, and found the expected results - which match those on SQL Server 7.
Has anyone run into this?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|