select t.*
from (select a.*,row_number() over( partition by a.cloName order by a.BGRQ desc) rn
from t_sys_33 a) t
where rn = 1;
亲测 Mysql 8.0 是支持如上写法的,其他版本没测过哈
select t.*
from (select a.*,row_number() over( partition by a.cloName order by a.BGRQ desc) rn
from t_sys_33 a) t
where rn = 1;
亲测 Mysql 8.0 是支持如上写法的,其他版本没测过哈