How to Select a Subset in MySQL. The Structured Query Language, used in the MySQL database, has great flexibility for selecting subsets of data from database tables. SQL's SELECT statement shows ...

The thing that gets me is that from what I know, this is one feature of MySql that the big boys don't have (Oracle, Sql Server, IBM DB2). That is, the LIMIT syntax with offset feature.