Archives of the TeradataForum

Message Posted: Sun, 26 Aug 2012 @ 15:06:16 GMT

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

If you run a select and don't specify an order, then the rows will be returned in essentially a random order.

The TOP operator restricts the output to a maximum of the specified number of rows. The rows returned are from the beginning of the result set.

If you do not specify an order by clause, then TOP will return the "first" of the randomly ordered rows.

Unless you only want a random sample of rows, using TOP without an order by isn't predicable as to the nature of the rows returned to you.

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