Results portion

[Sergey Zolotaryov]

Is there a way to retrieve a portion of results using Derby? For
example, I want to get rows from 10 to 20 from a resultset. All dbs I
know of, have this feature, smth like "LIMIT n, m" , or "ROWS n TO m".
Also is there a way to retrieve the total number of rows in last
select?
Thank you.