MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

100,000 rows table, and i only want row 500-549, how do i do it?
Posted by: huizhang66
Date: June 03, 2005 10:17AM

Does new mysql let us write the sql like this in oracle?

select * from table1 where rownum <= 549 and rnum >= 500

instead of select all the rows and then delivery the 50 i wants to me, just select 50 rows i wants and delvery to me.

Thanks!

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
100,000 rows table, and i only want row 500-549, how do i do it?
huizhang66
June 03, 2005 10:17AM
Re: 100,000 rows table, and i only want row 500-549, how do i do it?
Chris Stubben
June 03, 2005 03:14PM
Re: 100,000 rows table, and i only want row 500-549, how do i do it?
huizhang66
June 03, 2005 04:12PM
Re: 100,000 rows table, and i only want row 500-549, how do i do it?
huizhang66
June 03, 2005 04:16PM


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.