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

crackhitler99_at_hotmail.com (crackhitler) wrote in message news:<3783cad7.0209171509.630d77fa_at_posting.google.com>...
> 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.

crackhitler99_at_hotmail.com (crackhitler) wrote in message news:<3783cad7.0209171509.630d77fa_at_posting.google.com>...
> 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.

Everybody has implemented something like that, but it is not in the ANSI standard. Limiting is possible in the API rather than the statement itself (look up for instance the SQL_ATTR_MAX_ROWS option for SQLSetStmtAttr in ODBC documentation). It is a feature which sets a selection criterion that is not dependent on the row contents, so some might find it distasteful.

Peter Gulutzan
Co-Author of SQL Performance Tuning Received on Wed Sep 18 2002 - 09:44:25 CDT