简单说table(SC) 就两列:科目(cid)和分数(score)
因为MySql不让top 3，只得LIMIT 3.
SELECT score FROM SC SC0
WHERE score IN (
SELECT score FROM SC
WHERE cid=SC0.cid
ORDER BY score DESC
LIMIT 3
) T2
;
结果报错：
ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/
ALL/ANY/SOME subquery'
咋办呢？
请指教。谢了！
