## Sql改造:Sql–嵌套子查询
**
1、第一层在原始sql上增加一层,起别名。
**
(Select 别名1.列名1,别名1.列名2, ROWNUM AS RN FROM
(原始sql-- Select列名1,列名2, FROM 表名 where 1 = 1 order by update desc)
)别名1 where ROWNUM <= ‘5’;
(Selec a.id,a.name, ROWNUM AS RN FROM
(原始sql-- Select列名1,列名2, FROM 表名 where 1 = 1 order by update desc)
)a where ROWNUM <= ‘5’;
2.在第一层上再加第二层,
(Select 别名2.列名1,别名2.列名2, ROWNUM AS RN FROM
(Select 别名1.列名1,别名1.列名2, ROWNUM AS RN FROM
(原始sql-- Select列名1,列名2, FROM 表名 where 1 = 1 order by update desc)
)别名1 where ROWNUM <= ‘5’;
) 别名2 where RN >= ‘0’;
(Select 别名2.列名1,别名2.列名2, ROWNUM AS RN FROM
(Select 别名1.列名1,别名1.列名2, ROWNUM AS RN FROM
(原始sql-- Select列名1,列名2, FROM 表名 where 1 = 1 order by update desc)
)别名1 where ROWNUM <= ‘5’;
) 别名2 where RN >= ‘0’;
oracle数据库实例:
恭喜!芝麻开花节节高。