How do I control the number of rows a querry shd return

MahendraSetty · #1 (**permalink**) 04-20-04, 10:58

Hi All,

I want to control the number of rows a querry should return ( Like SPUFI returning nrows). I have a querry which returns 500+ rows but I want to limit the output only to say 10 rows. This is nothing to do with the predicates.

Environment : DB2 OS390.

Any suggestions/ Ideas...

Thanks

Marcus_A · #2 (**permalink**) 04-20-04, 11:21

FETCH FIRST n ROWS ONLY

You may need version 7 for this, not sure.

MahendraSetty · #3 (**permalink**) 04-20-04, 12:46

Great... Thats exactly what I wanted.

Thanks

Internet Services

Web Development

Digital Marketing

Consumer Tech