http://www.perlmonks.org?node_id=163042


in reply to Re: The fine art of database programming
in thread The fine art of database programming

And there was me thinking it was:
SELECT * FROM table LIMIT 99, 21;
No WHERE clause in sight. If you want be be a bit more specific on how things are ordered (rather than insertion order (which I believe is defined as being the standard ordering)), you do
SELECT * FROM table ORDER BY col LIMIT 99, 21;
Still no WHERE clause.