Query: Select for top 10 records

select * from cb_accountcode_details where ROWNUM <= 10;