SEO

#1 (**permalink**) 02-26-2008, 03:58 PM

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

#2 (**permalink**) 02-26-2008, 03:58 PM

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

#3 (**permalink**) 02-26-2008, 04:01 PM

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.

#4 (**permalink**) 02-26-2008, 04:02 PM

Kangan,

feature is there in db2

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

that will give only 5 rows

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Retruning the first five rows of a query statement result