Re: Problem with rownum

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Thu, 13 Jan 2005 23:39:55 +0000
Message-ID: <r01eu01so374neiji468b0cu50mdm94fj5@4ax.com>

On Thu, 13 Jan 2005 14:27:04 -0800, DA Morgan <damorgan_at_x.washington.edu> wrote:

>Graeme D wrote:
>
>> I don't understand why oracle doesn't have something like LIMIT x,x liek
>> there is in MySQL... any ideas?
>
>I don't understand why MySQL doesn't have full relational integrity and
>the ability to perform transactional recovery ... any ideas?

Yes it does, and yes it can. Perhaps you're still only considering the features of older versions, or haven't read the manual recently?

A more helpful reply would be to point out how rownum in Oracle is determined, i.e. it's done before a sort, so an equivalent to MySQL's limit would involve a sorted subquery.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Thu Jan 13 2005 - 17:39:55 CST