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

Question

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

Answer 1

SELECT colum1,colum2FROM (SELECT *FROM table_nameWHERE cond1 = '条件') AWHERE ROWNUM <= 30ORDER BY colum3;

Answer 2

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