CREATE TABLE a(
t DATE,
STATUS VARCHAR(10)
);
INSERT INTO a VALUES(DATE'2020-6-1','Y'),
(DATE'2020-6-2','Y'),
(DATE'2020-6-3','Y'),
(DATE'2020-6-4','Y'),
(DATE'2020-6-5','Y'),
(DATE'2020-6-6','N'),
(DATE'2020-6-7','N'),
(DATE'2020-6-8','Y'),
(DATE'2020-6-9','Y'),
(DATE'2020-6-10','Y'),
(DATE'2020-6-11','Y'),
(DATE'2020-6-12','Y'),
(DATE'2020-6-13','N'),
(DATE'2020-6-14','N'),
(DATE'2020-6-15','Y'),
(DATE'2020-6-16','Y'),
(DATE'2020-6-17','Y'),
(DATE'2020-6-18','Y'),
(DATE'2020-6-19','Y'),
(DATE'2020-6-20','N'),
(DATE'2020-6-21','N'),
(DATE'2020-6-22','Y'),
(DATE'2020-6-23','Y'),
(DATE'2020-6-24','Y'),
(DATE'2020-6-25','N'),
(DATE'2020-6-26','N'),
(DATE'2020-6-27','N'),
(DATE'2020-6-28','Y'),
(DATE'2020-6-29','Y'),
(DATE'2020-6-30','Y');
COMMIT;
CREATE TABLE b(
id VARCHAR(10),
sdate DATE,
ldate DATE
);
INSERT INTO b VALUES('S001',DATE'2020-6-2',DATE'2020-6-8'),
('S002',DATE'2020-6-3',DATE'2020-6-26'),
('S003',DATE'2020-6-5',DATE'2020-6-15'),
('S004',DATE'2020-6-15',DATE'2020-6-30'),
('S005',DATE'2020-6-18',DATE '2020-6-27');
COMMIT;id的申请和受理日期之间超过了10个工作日的id。
最新发布