Archives of the TeradataForum

Message Posted: Mon, 17 Jul 2006 @ 21:09:30 GMT

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

If you are in V2R6, you can try some thing like this:

     SELECT TOP 5
     field1, field2
     FROM table
     ORDER BY 2 DESC;

Which is same as:

     SELECT field1, field2
     FROM table  QUALIFY ROW_NUMBER () OVER (ORDER BY field DESC) <= 5;

Thanks

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