|
|
Archives of the TeradataForum
Message Posted: Wed, 16 Dec 2015 @ 23:40:21 GMT
Subj: | | Error with order by clause in a View |
|
From: | | Chennapragada, Somasankaram |
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
| |