SQL每日一题(20211213)
SQL每日一题(20220114)
SELECT code, invtp, date start_date,
LEAD( date, 1, '9999-12-31' ) over ( PARTITION BY code ORDER BY invtp ) end_date
FROM t0914;
SQL每日一题(20211213)
SQL每日一题(20220114)
SELECT code, invtp, date start_date,
LEAD( date, 1, '9999-12-31' ) over ( PARTITION BY code ORDER BY invtp ) end_date
FROM t0914;