Archives of the TeradataForum

Message Posted: Wed, 03 Apr 2013 @ 22:43:20 GMT

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

Use QUALIFY statement

     Select ....
     From ....
     Where ....
     Qualify row_number() over (partition by ... order by ...) < 32000

Look for other posts about Dense rank.

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA

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