SQLize Online / PHPize Online  /  SQLtest Online

create table jail ( gangster varchar null, jailtime_start date null, jailtime_end date null ) ; insert into jail values ('Иванов', '07.01.1990', '06.30.1991') ; insert into jail values ('Петров', '01.01.1993', '12.31.1993') ; insert into jail values ('Сидоров', '07.01.1993', '12.31.1994') ; insert into jail values ('Горин', '07.01.1994', '12.31.1995') ; insert into jail values ('Дудин', '07.01.1995', '12.31.1996') ; insert into jail values ('Зотов', '10.01.1995', '03.31.1996') ; insert into jail values ('Евегин', '07.01.1996', '06.30.1997') ; insert into jail values ('Зонгадзе', '01.01.1998', '12.31.1998') ; insert into jail values ('Колгин', '07.01.1998', '06.30.1999') ; insert into jail values ('Унегин', '01.01.1990', '12.31.1991') ; select * from ( select jailtime_end as _start, lead(jailtime_start) over(order by jailtime_end) as _end from jail )t where _end - _start > 1