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。