This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to obtain a resultset having fixed records

 
smitha rai
Ranch Hand
Posts: 33
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I want to query the database and get the resultset for the first 10 records OR next 10 records OR any recordsbased on row number. I used rownum in my select query, but it works for only first record. Apprecite if some one could help me out.
Regards,
Smitha
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"smitha",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Please change your display name immediately since accounts with invalid display names get deleted. 14 posts is too many
Thanks.
Dave
 
Tanel Alumae
Greenhorn
Posts: 14
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I understand correctly, what you want to do is called resultset paging.
You can find much information on this topic in this thread
An exhaustive review of the topic with implementation is given in this article at serverside.com
[ September 09, 2002: Message edited by: Tanel Alumae ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic