Re: How to Retrieve particular rows ?.

AFAIK the rownum value gets assigned before the order by takes place. This means that the order by is only being applied to the first ten rows that would normally be retrieved without the order by clause.

Luke

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!