...

View Full Version : rows between 10 and 20



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

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

angst
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}]

guelphdad
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