2018年10月25日
mysql 5.8 查询最新一条数据
摘要： SELECT * FROM ( SELECT temp.*, @rn := IF(@prev = order_id,@rn + 1,1) AS rn, @prev = 1 FROM (SELECT * FROM or_task_node ORDER BY created_date DESC) temp JOIN (SELECT @rn := 0) AS vars ) t WHERE t.rn =... 阅读全文
posted @ 2018-10-25 17:10 huanghaunghui 阅读(319) 评论(0) 推荐(0)