Results 1 to 3 of 3

Thread: Oracle 8i

  1. #1
    Join Date
    Dec 2004
    Posts
    1

    Unanswered: Oracle 8i

    I want to disploay records in a specified range. Let's say If I put
    START=1 & END=10; I should also be able to see the Records in between like
    2 & 9 even after putting the Constraint of START=1 & END=10;

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Do you mean:

    SELECT * FROM table
    WHERE col BETWEEN 1 AND 10;

    ?

  3. #3
    Join Date
    Jan 2004
    Posts
    492
    That or he means 10 records in total?

    select * from
    (select * from table
    order by some_col)
    where rownum <= 10
    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •