Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > General Computer Discussion > Software > Fetching middle rows from the database

Thread Tools

Fetching middle rows from the database

geetha geetha is offline
Junior Member
Join Date: Aug 2008
Posts: 2
I have a question, I would like to know how to fetch, in between rows from the table. Say for example, I have 1000 records in my table named employee. I would like to fetch the records between 500 and 600. How can I do that?

I read few forums and came to know that fetching top, bottom or middle rows from the table is meaningless unless we use orderby clause. Bcos there is no particular sequence available in the database.So if I use rownum pseudo column name to find top n bottom records using orderby clause.

Can somebody help me out with the answer on how to fetch the middle few hundreds of records.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Database Database Database Computer Information 0 09-27-2012 02:43 AM
DataBase DataBase DataBase DataBase Computer Information 0 09-26-2012 09:40 AM
dynamically add new rows and save data typed in these rows to a database Arjen Hoekstra ASP .Net 0 08-02-2005 12:15 PM
choices regarding where to place code - in the database or middle tier Joe Java 71 06-24-2004 08:58 PM
problem fetching the total number of rows newbie bhat Perl Misc 0 09-22-2003 09:57 AM