Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2006 @ 10:30:07 GMT


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


Subj:   Usage of TOP function
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, March 21, 2006 22:39 -->

Hi all,

Im new to Teradata. I have seen an SQL written like Select TOP 50 * from <tablename> , which purportedly returns the 'first' 50 rows. But, since there cannot be 'first' or 'last' rows in a table of an RDBMS, there must be an implicit order by. I tried to figure that out but did not meet with any success.

My question now is whether TOP function without an order by selects rows at random or is there any default order by column. Please let me know.


Regards



     
  <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