题解 | 支付间隔平均值
支付间隔平均值
https://www.nowcoder.com/practice/847431ad931e45348eb1ab5657144c28
select
cast(avg(abs(timestampdiff(second, a.logtime, b.logtime))) as signed) as gap
from
order_log a
join select_log b on a.order_id = b.order_id
cast(值 as signed) 数据类型转换函数，signed是整数，要把signed写成int要在mysql8.0环境中才可以，signed是通用的。
查看19道真题和解析