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

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Wed, 18 Sep 2002 08:21:10 -0400
Message-ID: <3D886FB6.5000907@ca.ibm.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.
>

Because both Oracle and DB2 can achive the same function using the OLAP Rownumber function (also ANSI)?
Given that this is also in the standard there is no need to waste resources....

Cheers
Serge

-- 
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Toronto

Try the DB2 UDB V8.1 beta at
http://www-3.ibm.com/software/data/db2/

Received on Wed Sep 18 2002 - 07:21:10 CDT