Hi All,
I am experiencing a strange thing, please let me know if this is normal.
I am using oracle 8.1.7.4 and solaris 2.8.
I am using this query.
select * from (select * from cemp order by cstatus) where rownum < 10;
Will the above query give the same records every time i execute the query. Will rownum give the first 9 records. If no ..why?
what do i do to get the first 9 records.
regards
anandkl