how toget values between 5th and 10th rows

[SKNaidu]

hi
i want to retrieve the values of rows between 5th and 10th rows out of 500 rows in a table.
thanks
SKNaidu

[hrishy]

Hi

You should have a date column in the table..then you can select between 5th and the 10th row..otherwise its not possible in relational database..

By the whats the criteria of 5th and 10th row in a 500 row table ?


regards
Hrishy

[nik_flash]

try using rownum
for e.g-
select customerid from customer where rownum <11
MINUS
select customerid from customer where rownum<6;

Originally posted by SKNaidu
hi
i want to retrieve the values of rows between 5th and 10th rows out of 500 rows in a table.
thanks
SKNaidu

[chrisrlong]

Oh no no no no.

Do not use MINUS for this proble - ROWNUM is the proper solution.

You can add paging to any query by wrapping it in paging logic:

SELECT 
   * 
FROM 
   ( 
   SELECT 
      INNER.*, 
      ROWNUM 
         AS QUERY_ROWNUM 
   FROM 
      ( 
      SELECT
         O.ORG_PK      ,
         OH.DSPLY_NM
      FROM
         ORG      O   ,
         ORG_HDR   OH
      WHERE
         O.ORG_DBA_NM   LIKE   :ORG_NM   ||   '%'   AND
         OH.ORG_PK      =      O.ORG_PK
      ORDER BY
         O.ORG_PK
      ) INNER 
   WHERE 
      ROWNUM <= :EndRow
   ) OUTER
WHERE
   OUTER.QUERY_ROWNUM >= :StartRow

- Chris