SELECT *
FROM (SELECT T.*, ROWNUM RN
FROM (要查询的东西直接写在这里即可) T
WHERE ROWNUM <= 10)
WHERE RN >= 0
如果在XML中配置注意字符转义:
&(逻辑与) &[color=red];[/color]
<(小于) <
>(大于) >
"(双引号) "
'(单引号) '
SELECT *
FROM (SELECT T.*, ROWNUM RN
FROM (要查询的东西直接写在这里即可) T
WHERE ROWNUM <= 10)
WHERE RN >= 0