Archives of the TeradataForum
Message Posted: Wed, 15 May 2002 @ 17:25:24 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|