Top N in Oracle 8.0.5

From: ivan vasquez <ivan_at_itos.uga.edu>
Date: Mon, 1 Jul 2002 13:20:19 -0400
Message-ID: <afq30j$f5r$1@cronkite.cc.uga.edu>

Hi,

How do I create a top-N query in Oracle 8.0.5?

The top-N has to happen after sorting the input, but ordered subqueries weren't allowed prior to 8i. All the documentation I've found is related to 8i, still no luck with this version!

INSERT INTO PA_ASSIGN
SELECT * FROM (
    SELECT *
    FROM PA_SELECT
    WHERE code = xPlSqlVariable1
    ORDER BY col1, col2, col3
WHERE ROWNUM <= xPlSqlVariable2;

Any hints are greatly appreciated.

Thanks,
Ivan. Received on Mon Jul 01 2002 - 12:20:19 CDT