SELECT
user_id,
order_code,
create_time,
LEAD (create_time, 1) OVER (
#返回的值是向前一行的orderDate,没有定义后续行,返回NULL。
PARTITION BY user_id
ORDER BY
CREATE_time DESC
) nextCreateDate
FROM
pay
ORDER BY
user_id DESC;
MySQL lead() 查询相邻数据的字段
最新推荐文章于 2022-09-21 08:56:08 发布