从DB里提取钱几条记录的语句
数据库取前几条记录的语句1. ORACLESELECT * FROM TABLE1 WHERE ROWNUM<=N2. INFORMIXSELECT FIRST N * FROM TABLE1 where 1=13. DB2SELECT * ROW_NUMBER() OVER(ORDER BY COL1 DESC) AS ROWNUM WHERE ROWNUM<=N或者SELECT COLUMN FROM TABLE where 1=1 FETCH FIRST N ROWS ONLY4. SQL SERVERSELECT TOP N * FROM TABLE1 where 1=1orSET ROWCOUNT N SELECT * FROM TABLE1 where 1=1 SET ROWCOUNT N15. SYBASESET ROWCOUNT N SELECT * FROM TABLE1 where 1=1 SET ROWCOUNT N16. MYSQLSELECT * FROM TABLE1 where 1=1 LIMIT N7. FOXPROSELECT * TOP N FROM TABLE ORDER BY COLUMN8. ACCESSSELECT TOP N * FROM TABLE1 where 1=1
页:
[1]