selcet score ,c_id from sc where c_id=1 order by score limit0,3;

select  from sc  as s1 where s1.score in
(select score from sc where s1.c_id=c_id group by c_id order by score desc limit0,3);