Archives of the TeradataForum
Message Posted: Wed, 16 Dec 2015 @ 23:40:21 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|