数据库取前几条记录的语句
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?
查询每组的前几条数据
?
SELECT s1.*FROM STUDENT AS s1WHERE (SELECT COUNT(1) FROM STUDENT AS s2 WHERE s2.Score >= s1.Score AND s2.Class = s1.Class) <= 10ORDER BY Class, Score DESC?
?
?
?
