My Interesting J2EE blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment