Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Wed, 22 Oct 2008 @ 14:24:50 GMT


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


Subj:   Re: First Row Function
 
From:   Dieter Noeth

Joerg Mutsch wrote:

  does anyone know if Teradata has something simular to the 'FIRST ROWS' function of Oracle?  


There's no function with that name in Oracle, only a hint named FIRST_ROWS. But in DB2 there's a "FETCH FIRST x ROWS ONLY".

Maybe "SELECT TOP x" is what you're looking for. Btw, this is similar to RANK/ROW_NUMBER/PERCENT_RANK.


  I am not sure but i thought I heard something about that at the last technical Conference in Berlin.  


I can't remember anything like that, but i attended just a few presentations, because i mainly went there to visit some old friends ;-)


Dieter



     
  <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: 28 Jun 2020