MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: 100,000 rows table, and i only want row 500-549, how do i do it?
Posted by: Chris Stubben
Date: June 03, 2005 03:14PM

Hi,

Use LIMIT... Its much better than the rownum pseudocolumn stuff since you can order the table any way you like.

select * from table1 LIMIT 500, 50


Chris

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.