取最新的数据

select
substring_index(group_concat(col_id order by col_importtime desc), ',', 1) as col_id
from
biwarehouse.tbl_gf_ext_manabcode_receiver
group by
col_usercode