sql业务常用

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

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

posted on 2019-12-04 18:13  gendway  阅读(215)  评论(0编辑  收藏  举报