Archives of the TeradataForum
Message Posted: Wed, 22 Mar 2006 @ 10:30:07 GMT
<-- Anonymously Posted: Tuesday, March 21, 2006 22:39 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|