换句话说 右边表 如何只用查询语句 不使用函数 实现呢
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 May 24, 2017
top 1
order by |
Select Language