select emp.*, rownum from emp where rownum=1;
o/p:
Name ID Salary Jobid Rowid
ABCD 101 12000 10 1
While giving more than one 1 in rownum column, didn't get output. Can some one please explain what is the logic behind that?
select emp.*, rownum from emp where rownum=2;
O/p:
No data found