select * from 表1where 缴费日期 in ( select max(缴费日期) as 缴费日期 from 表1 group by 编号)order by 编号 asc 类似这样的思路吧
