Group by & Distinct

From: raj Agarwal <rka.ra_at_worldnet.att.net>
Date: 1996/05/30
Message-ID: <4oirqv$8mk_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1


In a query that has a 'group by' , will a 'distinct' give any different result?

As a group by will group all same values into one row, I think the distinct will not change the result set.

Is this correct? If not correct would appreciate a sample query and data sample where the above is not true.

Thanks,

raj Received on Thu May 30 1996 - 00:00:00 CEST

Original text of this message