Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2006 @ 12:48:19 GMT

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

TOP function without an order by selects rows retrieve random rows. If you want the really top 50 rows you must use the order by clause..

for example:

     SELECT TOP 50 * FROM orders ORDER BY ship_date DESC;

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