Mysql查询用户最后一次充值时间

 

 

 方法一

 SELECT user_id,sumAmount,max(op_time) from test GROUP BY user_id


方法二
 SELECT * from (SELECT * from test ORDER BY op_time) b GROUP BY user_id