EMPNO SALARY
1 100
2 200
3 300
4 400
5 500
6 500
7 700

With rownum you get 500 once, and you don't know which empno.