1、查询lianxi2表,按id降序
select * from lianxi2 group by id desc
2、查询lianxi3表,按grade升序
select * from lianxi3 group by grade
select * from lianxi3 group by grade,id
注:如果同一个表中多个同学分数相同,首先根据分数进行分组,然后再根据id进行分组
1、查询lianxi2表,按id降序
select * from lianxi2 group by id desc
2、查询lianxi3表,按grade升序
select * from lianxi3 group by grade
select * from lianxi3 group by grade,id
注:如果同一个表中多个同学分数相同,首先根据分数进行分组,然后再根据id进行分组