Re: Ultimate Question: Oracle, MSSQL, Others vs MYSQL LIMIT Statement

From: Dieter Nöth <dnoeth_at_gmx.de>
Date: Wed, 18 Sep 2002 09:20:34 +0200
Message-ID: <am99g1$3lcb4$1@ID-28204.news.dfncis.de>

crackhitler wrote:
> For those of you looking to simulate a MySQL limit statement, try this
> article:
>
> http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/31/pid/333/qid/324945
>
> Why nobody other than the folks at MySQL have implemented a 'limit'
> clause (it's in the ANSI standard) is beyond me.

Which ANSI standard? Definitly not SQL ;-) There's no LIMIT clause up to the new drafts for SQL:200x, LIMIT's not even a keyword.

And it will probably never be a part of standard SQL, because you can achieve the same using ROW_NUMBER.

Dieter Received on Wed Sep 18 2002 - 02:20:34 CDT