SELECT * FROM tableName WHERE ROWNUM <= n
或
SELECT * FROM ( SELECT * FROM tableName order by column1 ) WHERE ROWNUM <= n
如果只要取最大或最小的,請善用MAX()或MIN()。
全站熱搜
SELECT * FROM tableName WHERE ROWNUM <= n
或
SELECT * FROM ( SELECT * FROM tableName order by column1 ) WHERE ROWNUM <= n
如果只要取最大或最小的,請善用MAX()或MIN()。
留言列表