Re: Top n in sql

From: <shiling_at_math.wayne.edu>
Date: Sun, 06 Jun 1999 23:46:33 GMT
Message-ID: <7jf18o$8sn$1@nnrp1.deja.com>

ORDER BY does work in sub-query in the version 8 for windows which I downloaded four weeks ago.

The Ken Atkins' Oracle Database Tip is really good web page to read and to understand the top n selection problem.

I believe PL/SQL is the solution if ORDER BY does work in sub-query in the version 8, or finish it in two pieces of queries.

http://www.arrowsent.com/oratip/tip38.htm

> The above solution does not appear to work in
> Oracle 7.3.3, apparently because of the ORDER BY
> in the sub-select. Is this restricted to 8.x?
>
> Thanks,
>
> Geoff Houck
> systems hk
> hksys_at_teleport.com
> http://www.teleport.com/~hksys
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Jun 06 1999 - 18:46:33 CDT