Archives of the TeradataForum

Message Posted: Thu, 04 May 2006 @ 10:18:53 GMT

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

Gopi:

If you are getting different row count numbers on each run, my guess is that C10 is not unique and therefore each time you execute it the sort on the one column yields different sequencing of the rows.

Add another column to the order by inside the ROW_NUMBER function in your derived table - BTW, subqueries are referenced in a WHERE and tables are referenced in a FROM. You have a table here and not a subquery.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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