November 20, 2006 at 10:02 am
Hi everybody,
Anybody know why group by is catching duplicates better than distinct?
When I compare the same columns, for example
select a,b,c from table1 group by a,b,c
vs
select distinct a,b,c from table1
the distinct query doesn't catch all of the duplicates for those certain columns I am looking at in my database, which has about 200,000 rows....doesn't that query do the same thing?
November 20, 2006 at 11:17 am
Impossible... please post the queries you are using!
Distinct and group by are used for different things, but certainly not on that matter.
November 20, 2006 at 12:28 pm
There were some issues at one point in time with group by an user defined functions but none ( that I know off ) with columns.
If your query is grouping user defined function results, make sure you have the latest Service Pack installed.
Cheers!
* Noel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply