
换句话说 右边表 如何只用查询语句 不使用函数 实现呢
select s.settlement_id,h.updated_at,from_unixtime(max(h.updated_at)) from settlement as s left join settlement_update_history as h on s.settlement_id = h.settlement_id where s.settlement_id= 6383 group by s.settlement_id
1 SummerWQM OP 顶一下 |
2 xkx 2017-05-24 17:40:03 +08:00 top 1 order by |