Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2006 @ 10:30:07 GMT

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

<-- Anonymously Posted: Tuesday, March 21, 2006 22:39 -->

Hi all,

Im new to Teradata. I have seen an SQL written like Select TOP 50 * from <tablename> , which purportedly returns the 'first' 50 rows. But, since there cannot be 'first' or 'last' rows in a table of an RDBMS, there must be an implicit order by. I tried to figure that out but did not meet with any success.

My question now is whether TOP function without an order by selects rows at random or is there any default order by column. Please let me know.

Regards

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