结算卡号有重复数据,取出最新的结算卡号数据:
SELECT * FROM (SELECT * FROM test1 ORDER BY create_time DESC)t GROUP BY bill_code