with a as (
select sls , st , sm , count(1) as dd
from dd where (sm like 'aa%' OR sm like 'bb%')
group by sls , st , sm having count(1) > 1
)
select * from a;
select sls , st , sm , count(1) as dd
from dd where (sm like 'aa%' OR sm like 'bb%')
group by sls , st , sm having count(1) > 1
)
select * from a;