DB2 rownum - oracle

* 반환되는 행의 갯수 제한 하기!

 

oracle 

    select *

      from table

     where rownum <= 10

 

 

 

db2

   select *

       from table

    fetch first 10 row only

 

  select *

     from ( select row_number() over (oreder by id)  as r_number

                      from table)

  where r_number <= 10