sql业务常用

结算卡号有重复数据，取出最新的结算卡号数据:　　

SELECT * FROM (SELECT * FROM test1 ORDER BY create_time DESC)t GROUP BY bill_code