Archives of the TeradataForum

Message Posted: Fri, 20 Jul 2012 @ 18:57:51 GMT

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

Hi,

Without any ORDER BY clause the TOP function returns 'any' rows.

With an ORDER BY clause, I always tell students to interpret this function as returning the "First n" rows based on the specified sort criteria (i.e. the ORDER BY). This makes it easier to understand when thinking about the highest or lowest rows in the answer set base don the ORDER BY criteria.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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