LIMIT problem

[essjay_d12]

I am using the following .... select * from house LIMIT 10, 20;

 

yet this produces 13 rows, surely it should only produce 11?

 

thanks

 

d

[obsidian]

The way you currently have it, it is starting with row 10 and limiting your results to 20 rows, so it sounds like your table has about 23 records in it. Try either of the following:

SELECT * FROM house LIMIT 20, 10;
SELECT * FROM house LIMIT 10 OFFSET 20;

[fenway]

I am using the following .... select * from house LIMIT 10, 20;

 

yet this produces 13 rows, surely it should only produce 11?

 

thanks

 

d

Actually, it shouldn't produce any more than 10.

[unidox]

SELECT * FROM table LIMIT 10, 20 should work. Unless you have the same id, but i think that is impossible