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

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)