Archives of the TeradataForum

Message Posted: Wed, 15 May 2002 @ 17:25:24 GMT

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

Hi JC:

The best way to do this is to use the RANK function. You can sort in it to obtain the desired sequence and use QUALIFY to indicate how many rows you wish to return.

Mike

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