I was wondering what you do when say record 1001 gets deleted...your second query will only return 9 rows. It's explained in your linked slides that LIMIT is o

I was wondering what you do when say record 1001 gets deleted...your second query will only return 9 rows. It's explained in your linked slides that LIMIT is ok, it's the offset that you need to worry about so your query looks like it would be better written: SELECT * FROM t WHERE id > 1000 LIMIT 10;