Archives of the TeradataForum

Message Posted: Tue, 03 Dec 2002 @ 11:38:08 GMT

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

Including the DISTINCT clause in a SQL query results in elimination of duplicate rows. The DISTINCT applies to the entire row & not to any single column.

Ex. SELECT DISTINCT a,b,c FROM x;

Here DISTINCT does not mean just "a' being unique, but the combination of a,b & c

Sanjay

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