Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 05 Jul 2005 @ 09:19:00 GMT


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


Subj:   BTEQ-LIMIT and Oracle ROWNUM
 
From:   Aananth.S

Hello All,

In Oracle, we have a rownum (psudo column) that can limit the number of rows being returned from the DB srvr. Is there a equvalent in TD? From what i understand, the BTEQ LIMIT keyword gets all the rows from the Srvr and displays only the LIMITED rows. What Iam exactly interested in is the performance implications of something like ROWNUM. we have used it extensively in places where EXISTS like conditions have to be used in Oracle. Pls comment!


Thanks

Aananth



     
  <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: 27 Dec 2016