Select a subset of records

Hi,

I'm an italian student and I've a problem with the selection of subsets of records.
I do this selection with the following query:

SELECT cols
FROM (
  SELECT cols
  FROM table
  WHERE where_clause
  ORDER BY order_clause
)
WHERE ROWNUM BETWEEN limit1 AND limit2

I think that this query is not efficient! Can you help me?

Thank you.
Giuseppe

P.S.: Scuse me for my terrible english!!! Received on Mon Oct 09 2006 - 10:18:25 CDT