如图,如果我们按 number 分组后再按 is_bak 从大到小排序获取最大的第一条数据,那么最后结果就是 id 为 1,4,6 这 3 条。
select t.* from (
select distinct(id) as tt,t1.* from a_t as t1 order by is_bak desc
) as t group by number order by id asc;
参考
https://blog.csdn.net/persistencegoing/article/details/92764058