ORACLE: select * from (select a.rownum,a.* from dual) b where b.rownum=1 DB2: select * from txtj fetch first 1 rows only