Result difference in Oracle 184.108.40.206.0 vs 220.127.116.11.0
Hi All.... I have an issue with a select query. It behaves differently in Oracle 18.104.22.168.0, it works fine in 22.214.171.124.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.