常用的Sql命令之查询5

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进行分组