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

A long time ago, in a galaxy far, far away, crackhitler99_at_hotmail.com (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. I expect Microsoft to
> behave like this but not Oracle.

That is very curious. In which ANSI standard do you think LIMIT was introduced?

I presume you can tell us what section of the standard it is described in?

Alternatively, maybe 'nobody' has implemented it because it's NOT in any of the standards documents, and thus ISN'T standardized.

-- 
(concatenate 'string "cbbrowne" "@acm.org")
http://cbbrowne.com/info/rdbms.html
Some people are only alive because it is illegal to kill.