Home Page for the TeradataForum

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 ;-)


  <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