any_value()会选择被分到同一组的数据里第一条数据的指定列值作为返回数据
select ord2.client_id,any_value(pay_time) from
(select pay_time,client_id,pay from ccp_order order by pay_time desc) ord2
group by ord2.client_id
select ord2.client_id,any_value(pay_time) from
(select pay_time,client_id,pay from ccp_order order by pay_time desc) ord2
group by ord2.client_id