Retruning the first five rows of a query statement result

[Kangan]

Hi,
Is there a way to display just the first five rows of the query stt
result in DB2. I know that there is something called select Top 5 *
from tablename in SQL Server 2000. Is there a wayaround, if there are
no stts in DB2, ie if we can use two or three DB2 sql stts to achieve
this result.
-Thanks
Kangan

[Blair Adamache]

select * from address order by name fetch first 5 rows only

Kangan wrote:

Hi,
Is there a way to display just the first five rows of the query stt
result in DB2. I know that there is something called select Top 5 *
from tablename in SQL Server 2000. Is there a wayaround, if there are
no stts in DB2, ie if we can use two or three DB2 sql stts to achieve
this result.
-Thanks
Kangan

[P. Saint-Jacques]

Try: select .... from table .... fetch first 5 rows only
HTH, Pierre.

Kangan wrote:

Hi,
Is there a way to display just the first five rows of the query stt
result in DB2. I know that there is something called select Top 5 *
from tablename in SQL Server 2000. Is there a wayaround, if there are
no stts in DB2, ie if we can use two or three DB2 sql stts to achieve
this result.
-Thanks
Kangan

--
Pierre Saint-Jacques
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

[Lekharaju]

Kangan,
feature is there in db2

select col1,col2,....
from tab1
where col1 = ?
fetch first 5 rows only

that will give only 5 rows