摘要： select * from ( select rownum as sn,a.* from ( select table_name,num_rows from user_tables where num_rows is not null order by num_rows desc ) a ) b where b.sn<11; 阅读全文