查询前几条记录在不同数据库中的用法 1. ORACLESELECT * FROM TABLE1 WHERE ROWNUM<=N2. DB2SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=N或者SELECT COLUMN FROM TABLE FETCH FIRST N ROWS ONLY3.
Copyright © 2005-2025 51CTO.COM 版权所有 京ICP证060544号
