mysql8写法,5.7没有这个函数
SELECT
NAME,
DATE,
# lag(DATE) OVER(PARTITION BY NAME ORDER BY DATE) AS pre
lead(DATE) OVER(PARTITION BY NAME ORDER BY DATE) AS NEXT
FROM test;
mysql8写法,5.7没有这个函数
SELECT
NAME,
DATE,
# lag(DATE) OVER(PARTITION BY NAME ORDER BY DATE) AS pre
lead(DATE) OVER(PARTITION BY NAME ORDER BY DATE) AS NEXT
FROM test;