SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE tab1( st_dt date, end_dt date); INSERT INTO tab1 (st_dt, end_dt) VALUES (TO_DATE('2022-08-01', 'YYYY-MM-DD'), TO_DATE('2022-08-05', 'YYYY-MM-DD')), (TO_DATE('2022-08-06', 'YYYY-MM-DD'), TO_DATE('2022-08-15', 'YYYY-MM-DD')), (TO_DATE('2022-08-20', 'YYYY-MM-DD'), TO_DATE('2022-08-25', 'YYYY-MM-DD')), (TO_DATE('2022-08-28', 'YYYY-MM-DD'), TO_DATE('2022-08-30', 'YYYY-MM-DD')); WITH tbl AS ( SELECT st_dt, end_dt, lead(st_dt, 1) over (order by st_dt) as lg, end_dt + 1 as ed FROM tab1) SELECT *, CASE when lg <> ed then 'разрыв в истории' else 'нет разрыва в истории' end as dq FROM tbl;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear