Archives of the TeradataForum

Message Posted: Fri, 11 Feb 2005 @ 19:00:43 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Guidelines for using Distinct vs. group by

From:		Duell, Bob

Dieter wrote:

- And don't forget that a subquery is automatically distinct, but using Group By overrides that.

I'm sure I'm missing something. Are you saying all subqueries have an implicit "distinct"?

Bob

BTW - A day rarely goes by that I don't learn something very valuable form this list.

Thanks to all.


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2005 Indexes

Last Modified: 15 Jun 2023