Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023