用Oracle和mysql分别查询数学成绩前3名的学生信息

oracle查询：

SELECT *
  FROM (SELECT S.SNO, ST.SNAME, S.CNO, S.SCORE, C.CNAME
          FROM SCORE S, COURSE C, STUDENT ST
         WHERE S.CNO = C.CNO
           AND S.SNO = ST.SNO
           AND C.CNAME = 'Java Web'
         ORDER BY S.SCORE DESC)
 WHERE ROWNUM < 4;

mysql查询：

 SELECT S.SNO, ST.SNAME, S.CNO, S.SCORE, C.CNAME
   FROM SCORE S, COURSE C, STUDENT ST
  WHERE S.CNO = C.CNO
    AND S.SNO = ST.SNO
    AND C.CNAME = 'Java Web'
  ORDER BY S.SCORE DESC
  LIMIT 0,4;

或者

 SELECT S.SNO, ST.SNAME, S.CNO, S.SCORE, C.CNAME
   FROM SCORE S, COURSE C, STUDENT ST
  WHERE S.CNO = C.CNO
    AND S.SNO = ST.SNO
    AND C.CNAME = 'Java Web'
  ORDER BY S.SCORE DESC
  LIMIT 4;

换句话说，LIMIT n 等价于 LIMIT 0,n。