Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I use ROWNUM in a subquery (emulating SQL Server TOP n)

Re: How do I use ROWNUM in a subquery (emulating SQL Server TOP n)

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 29 Nov 2004 07:51:57 -0800
Message-ID: <1101743427.501723@yasure>


Gosta Hulden wrote:

> Sybrand,
>
> If my question is so basic that I can just look it up in the
> documentation. Howcome the Oracle Migration Workbench wasn't able to
> migrate the query. It has migrated thousand of TOP N queries that
> works, but this is in a different context which is more tricky, and
> the usual way to solve TOP N does not work.
> I bet you can't solv it either, reading the documentation or not...
> Best regards
> /Gosta

Because the Migration Workbench is of limited utility. Code it generates should be considered, at best, a starting point but hardly usable.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Nov 29 2004 - 09:51:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US