0 Replies Latest reply on Apr 21, 2014 1:23 PM by Jaan N

    Oracle vs SQL Behaviour in displaying TOP N

    Jaan N

      I have a report where Top 5000 records are being displayed using 'Number of Records' field in filter.

      I created two reports, one for SQL and one for Oracle. Query that I am using in both the reports is giving the same result and report is also displaying as expected.

      But when I use Top 5000 in filter, displayed results are not same in SQL vs Oracle.

      Appreciate any help.

      TopNSQLvsOracle.png