select count,strategy_id from (select count(*) count ,strategy_id from publish.dim_strategy

group by strategy_id) sub

where count=1

This would give the strategy_id that appeared once but i want to make sure that efct_end_dt is...