SELECT * FROM (
SELECT m.*, ROWNUM as ROWNUM2 FROM (
--查询语句
SELECT b.* FROM coalbytrain b order by b.coalbytrainid asc
) m
WHERE ROWNUM <= 20 ) WHERE ROWNUM2 > 0
SELECT m.*, ROWNUM as ROWNUM2 FROM (
--查询语句
SELECT b.* FROM coalbytrain b order by b.coalbytrainid asc
) m
WHERE ROWNUM <= 20 ) WHERE ROWNUM2 > 0