数据库取前几条记录的语句

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 

?

?

?