Archives of the TeradataForum
Message Posted: Wed, 22 Oct 2008 @ 14:24:50 GMT
| 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 ;-)