Hi,

Can anyone tell me is there any syntax in DB2 similar to rownum in oracle.

Say in oracle i can give select * from employee where rownum > 5 or delete from emp where rownum >6;
is there something similar to that in DB2.

Thanks,
Amit

DB2 & UDB email list listserv db2-l LazyDBA home page