Strange behaviour with DENSE_RANK and IN

Strange behaviour with DENSE_RANK and IN

References

Reference NO 1

http://stackoverflow.com/questions/13582355/strange-behaviour-with-dense-rank-and-in

Reference NO 2

http://stackoverflow.com/questions/18190832/sql-dense-rank-function

Reference NO 3

http://stackoverflow.com/questions/5802294/issue-with-ordering-results-in-dense-rank

Reference NO 4

http://stackoverflow.com/questions/7476946/sql-server-dense-rank

Reference NO 5

http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2920665938600

Reference NO 6

https://forums.oracle.com/thread/2383062

Reference NO 7

#EANF#

Reference NO 8

#EANF#