Archives of the TeradataForum

Message Posted: Tue, 03 Oct 2006 @ 21:21:05 GMT

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

You could use an OLAP function like Row_number() OVER() as RowNUM to number each row.

Then a QUALIFY statement like

     QUALIFY ROWNUM <=2000;

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