asked
Result difference in Oracle 11.2.0.3.0 vs 11.2.0.2.0
Hi All.... I have an issue with a select query. It behaves differently in Oracle 11.2.0.3.0, it works fine in 11.2.0.2.0. SELECT SET_ID, SET_NAME FROM ADB WHERE ROWNUM < 10 ORDER BY SET_ID DESC. I have total of 100 records. This query works fine in 0.2 version returning top 10 records where as in 0.3 it returns bottom 10 records ordering it in descending order.
10 People are following this question.
