如题所述
select t1.* from
table as t1 left join
(select c as c1, max(b) as b1 from table group by c) as t2
on t1.c = t2.c1
order by b1 desc
没有环境验证,如果有语法错误就稍微改改来自:求助得到的回答
table as t1 left join
(select c as c1, max(b) as b1 from table group by c) as t2
on t1.c = t2.c1
order by b1 desc
没有环境验证,如果有语法错误就稍微改改来自:求助得到的回答
温馨提示:答案为网友推荐,仅供参考