SQL request that retreive a limited number of row

Dave Rush · #1 (**permalink**) 07-08-04, 11:29

Hi,

I would like to retrive with an SQL select statement a limited number of row.

On ADABAS:the request would be:

db2 "select * from tablename where rowno<=5"

This retreive 5 first row.

SQL0206N "ROWNO" is not valid in the context where it is used.
SQLSTATE=42703

Thanks

bmujeeb · #2 (**permalink**) 07-08-04, 11:32

use "fetch first <no_of_rows> rows only". after from clause.

regards,

mujeeb

Dave Rush · #3 (**permalink**) 07-08-04, 11:44

thanks a lot this is working

Dave Rush · #4 (**permalink**) 07-08-04, 12:12

thanks a lot this is working

Internet Services

Web Development

Digital Marketing

Consumer Tech