Kangan,


feature is there in db2

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

that will give only 5 rows