先排序后分组:
<select id="queryAllByApp" resultMap="BaseResultMap">
select * from (
select
<include refid="Base_Column_List"/>
from table_1
where app=#{app,jdbcType=VARCHAR} having 1 order by update_time desc
) as tablesample group by com_id
</select>