View Full Version : rows between 10 and 20

02-15-2007, 05:24 AM
I want to select all rows between 10 and 20 from a
view how can I do this?

02-15-2007, 07:29 AM
select * from table where 1 limit 10,10

02-15-2007, 03:41 PM
and so that you understand what these numbers mean for LIMIT:

[LIMIT {[offset,] row_count | row_count OFFSET offset}]

02-15-2007, 06:12 PM
note that without an order by clause there is no order to your table, so while you may get some results the same, you may not always get the same rows.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum