Archives of the TeradataForum

Message Posted: Thu, 24 Jun 2004 @ 13:34:22 GMT

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

Partho:

Thank you for clarifying your actual need. You don't use a WHERE for this, instead you use a QUALIFY, as in the following:

     Select ....  from ...
     QUALIFY row_number() OVER (ORDER BY ...) < 12

Regards,

Michael Larkins
Certified Teradata Master

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