如何使用存储过程 order by rownum ？

Question

现在希望将如下SQL语句方式存储过程中执行1000次 检查SQL的耗时SELECT colum1,colum2FROM (SELECT *FROM table_nameWHERE cond1 = '条件'ORDER BY colum3)WHERE ROWNUM <= 30;错误为需要INTO ，给colum1,colum2加into后，会在select*处报错，提示值不够，请问这样的SQL 应该在存过中怎么写才正确，感谢！

Answer 1

SELECT colum1,colum2
FROM (SELECT *
FROM table_name
WHERE cond1 = '条件') A
WHERE ROWNUM <= 30

ORDER BY colum3
;

Answer 2

table_name 中有 colum1,colum2吗?
请试试以下语句
SELECT t.colum1,t.colum2
FROM (SELECT *
FROM table_name
WHERE cond1 = '条件'
ORDER BY colum3) t
WHERE ROWNUM <= 30;