Orcleデータベースの成長の道1

 Orcle:
 Select tt,* from(select cc.*,rownum rn from(select * from    where   
 )tt where rownum<=10 )cc where rn>=1
 
 Mysql:
 select * from     where    limit 0，10