On Wed, Jan 14, 2009 at 6:27 PM, Roan Kattouw <roan.katt...@home.nl> wrote: [snip] > I knew about those, yes, but I didn't know LIMIT/OFFSET was > non-standard, even though it seems to be the more widely used variant. > Of course if offset handling isn't implemented at all, that's something > to worry about. [/snip]
MSSQL does something different too. The following bit of MySQL: SELECT * FROM tbl LIMIT 5; Would become the following in MSSQL: SELECT TOP 5 FROM tbl; Was definitely a headache on more than one occasion, being so used to typing limit... -Chad _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l