MySQL Forums
Forum List  »  Oracle

Re: Another ROWNUM problem
Posted by: juan antonio garcia
Date: August 12, 2005 06:07PM

Hi

I think you can use de LIMIT clause for make your query

select * from yourtable order by yourkey desc LIMIT 5,10

10 results since the rownum 5

Options: ReplyQuote


Subject
Views
Written By
Posted
9157
April 18, 2005 05:53AM
Re: Another ROWNUM problem
3459
August 12, 2005 06:07PM
3178
August 16, 2005 02:19AM
3136
October 06, 2005 08:35AM
3187
December 01, 2005 08:08AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.