换句话说 右边表 如何只用查询语句 不使用函数 实现呢
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 |