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