Archives of the TeradataForum

Message Posted: Wed, 16 Dec 2015 @ 23:40:21 GMT

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

Why do we get an error when we include order by clause in a View? And why is that we do not get error when we use top operator with order by clause with in the view.

I do understand that it is not necessary to order the intermediate results because it takes much processing and system resources. As per my understanding, Order by clause is not permitted in view because it is not the final result. But what I am unable to understand is why is it permitted with top operator.

Best Regards,

Shankar

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