排名前三的学生和分数
select c_name,grade from idoxu order by grade desc limit 3;
排名3-6名的学生和分数
select c_name,grade from idoxu order by grade desc limit 2,4
排名6名以后的所有学生和分数
select c_name grade from idoxu order by grade desc limit 5,666;
排名前三的学生和分数
select c_name,grade from idoxu order by grade desc limit 3;
排名3-6名的学生和分数
select c_name,grade from idoxu order by grade desc limit 2,4
排名6名以后的所有学生和分数
select c_name grade from idoxu order by grade desc limit 5,666;