Saturday, August 3, 2013

DB 2 - rownum


select * from (
    select a.ACCOUNT_ID, ROW_NUMBER() OVER() as rownum FROM USER a
)
where rownum between 300 and 400

No comments:

Post a Comment