create table t (a int); insert into t values (1); select distinct * from (select a, '2021-01-01' as st, '2021-01-02' as lt from t)x;