Result difference in Oracle 22.214.171.124.0 vs 126.96.36.199.0
Hi All.... I have an issue with a select query. It behaves differently in Oracle 188.8.131.52.0, it works fine in 184.108.40.206.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.