我正在努力解决这个问题.表有cycle and date
列,我想再添加一列作为 end date with interval of 100 days from current date
,并想显示cycle, start_date, end_date
作为输出.
我试过这个
select cycle, min(start) as startt, max(start) as endd
from cy
group by cycle ;
然而,直到现在,运气都不好.
其MYSQL DB最新版本.
CREATE TABLE table1 (
`cycle` INTEGER,
`date` DATE,
);
INSERT INTO table1
(`cycle`, `date`)
VALUES
('1', '15-Jan-21'),
('2', '01-Aug-21'),
('3', '08-sep-21'),
('4', '15-Dec-21');