Archives of the TeradataForum

Message Posted: Wed, 10 May 2006 @ 13:38:40 GMT

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

Another post gave an answer that will work on both new and older versions of Teradata. (Using Qualify(row_number ...))

If you are on a recent version (dont remember which one introduced the 'TOP' keyword) you can use:

     Select Top 50 c1, c2 ...

or

     Select Top 50 With Ties c1, c2 ...

You will need to use an Order By clause in order for TOP (or Qualify) to have any meaning of course.

Mike Dempsey
Teradata Client Tools

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