AndyXuq的专栏

select * from (select t.*,rownum row_num from (select * from table_name t order by t.id desc) t ) b where b.row_num between 1 and 10 来个例子： select * from (select t.*,rownum row_num from (sel

本文转载自百度问答：http://zhidao.baidu.com/question/51711259.html A表(a1,b1,c1) B表(a2,b2) a1 b1 c1 a2 b2 01 数学 95 01 张三 02 语文 90 02 李四 03 英语 80 04 王五 select