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