Jump to content


Photo

How to limit the # of rows..


  • Please log in to reply
1 reply to this topic

#1 SacredProductions

SacredProductions
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 28 September 2005 - 08:30 PM

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

#2 hvle

hvle
  • Members
  • PipPipPip
  • Advanced Member
  • 667 posts
  • Locationmelbourne, Australia

Posted 28 September 2005 - 11:08 PM

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

View Post


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;
Life's too short for arguing.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users