I'm migrating my database system to DB2,
i've can't figure out how to select a specific rows in a table,
I'm retrieving data to show it page-by-page, each page requires 10 rows only,
i want to retrieve only 10 rows everytime.

For mysql,
I'll use "Select * from account LIMIT 0,10"

For mssql,
I'll use "SET ROWCOUNT=10;Select top 10"

For DB2,
I've found out the FETCH FIRST 12 ROWS ONLY staff,
but thats only getting rows start from the first,
how if i want to get rows in the middle?

Thanks

search for
row_number() over(order by ....)

First of all, you will need an ordering criteria. If you don't have an ORDER BY clause (or use ORDER BY inside the ROW_NUMBER() function as Rahul has shown), then DB2 can return any arbitrary row.

Remember: Relational tables represent sets of rows, and sets are - per definition - not sorted. Thus, there is no concept like a "first row" or "second row".