分组后取得最新一条记录

select * FROM dwgl_partydues  WHERE create_time in (select MAX(create_time) from dwgl_partydues  GROUP BY idcard)

https://baijiahao.baidu.com/s?id=1722183211075287337&wfr=spider&for=pc