Archives of the TeradataForum

Message Posted: Fri, 21 Dec 2007 @ 18:28:12 GMT

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

Did you try ORDER BY 1,2,3?

If you are simply looking to not print any repeated data values then you should be using the .suppress 1,2 option within BTEQ.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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