insert into sample values(1,null,null);
insert into sample values(1,null,null);
insert into sample values(1,'2019-01-01','2019-01-01');
insert into sample values(2,null,null);
insert into sample values(2,null,null);
insert into sample values(3,null,null);
insert into sample values(1,'2019-02-01','2019-02-01');
7 rows affected
hidden batch(es)
select id from sample group by id having max(From_) is null and max(To_) is null;
id
2
3
…
Warning: Null value is eliminated by an aggregate or other SET operation.