-- 查各科成绩前三的学生
SELECT t1.stuId,t1.cid,num
FROM score t1
WHERE
(SELECT COUNT(cid)+1
FROM score t2
WHERE t1.cid= t2.cid AND t1.num<t2.num )<=3
ORDER BY t1.cid,num DESC
– 查询第三的学生
SELECT t1.stuId,t1.cid,num
FROM score t1
WHERE
(SELECT COUNT(cid)+1
FROM score t2
WHERE t1.cid= t2.cid AND t1.num<t2.num )=3