按最高分排序 order必须排group by后

Discuss / SQL / 按最高分排序 order必须排group by后

Back

Topic source

#1 Created at ... [Delete] [Delete and Lock User]

SELECT 'TODO';
select class_id [班级], gender [性别], max(score) [最高分]  from students
group by class_id, gender
order by max(score) desc

#2 Created at ... [Delete] [Delete and Lock User]

你这个都有问题，都出错，并且同时有order和group的情况下，你删掉group的结果也一样。