Fetching middle rows from the database

Discussion in 'Software' started by geetha, Aug 23, 2008.

  1. geetha

    geetha

    Joined:
    Aug 23, 2008
    Messages:
    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.

    Thanks.
    geetha, Aug 23, 2008
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Michel Christensen

    TB: fetching mail

    Michel Christensen, May 4, 2004, in forum: Firefox
    Replies:
    1
    Views:
    455
    Moz Champion
    May 5, 2004
  2. Avalanche

    Thunderbird fetching Yahoo mail

    Avalanche, Jul 7, 2005, in forum: Firefox
    Replies:
    1
    Views:
    2,788
    Ian Anderson
    Jul 7, 2005
  3. El Pea
    Replies:
    4
    Views:
    2,268
    El Pea
    Jan 11, 2004
  4. scott93727@gmail.com

    DataBase DataBase DataBase DataBase

    scott93727@gmail.com, Sep 26, 2012, in forum: Computer Information
    Replies:
    0
    Views:
    947
    scott93727@gmail.com
    Sep 26, 2012
  5. scott93727@gmail.com

    Database Database Database Database

    scott93727@gmail.com, Sep 27, 2012, in forum: Computer Information
    Replies:
    0
    Views:
    807
    scott93727@gmail.com
    Sep 27, 2012
Loading...

Share This Page