Jump to content

Archived

This topic is now archived and is closed to further replies.

SacredProductions

How to limit the # of rows..

Recommended Posts

Is there a way to limit the number of rows simply by specifying the number of the row? What would be the code to display rows such as - 10 through 20, or rows 30 through 40?

 

Thanks for any help!

 

- Ben

Share this post


Link to post
Share on other sites
Is there a way to limit the number of rows simply by specifying the number of the row? What would be the code to display rows such as - 10 through 20, or rows 30 through 40?

 

Thanks for any help!

 

- Ben

300595[/snapback]

 

add a limit to the end of query.

 

to select rom 10 to 20, you'd like to skip 9 rows, and get next 11 rows:

select ....... limit 9,11;

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.