题目
有如下一张表G0720
TS是时间戳 ,EVENTS是发生的事件编码
查询某事件发生后及其1小时内的所有记录。
预计结果如下:
测试语句
CREATE TABLE G0720
(
TS DATETIME,
EVENTS VARCHAR(50)
)
INSERT INTO G0720 VALUES ('2023-03-01 09:45:00','TH03001');
INSERT INTO G0720 VALUES ('2023-03-01 10:30:00','TH03001');
INSERT INTO G0720 VALUES ('2023-03-01 10:45:00','TH03001');
INSERT INTO G0720 VALUES ('2023-03-01 11:00:00','TH03001');
INSERT INTO G0720 VALUES ('2023-03-02 09:50:00','TH03002');
INSERT INTO G0720 VALUES ('2023-03-02 10:30:00','TH03002');
INSERT INTO G0720 VALUES ('2023-03-02 10:45:00','TH03002');
INSERT INTO G0720 VALUES ('2023-03-02 11:00:00','TH03002');