SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE ProductCommissionRates
    ([ProdCode] int, [CommRate] int, [RateDesc] varchar(7))
;
    
INSERT INTO ProductCommissionRates
    ([ProdCode], [CommRate], [RateDesc])
VALUES
    (00130, 10, 'Desc 17'),
    (00130, 20, 'Desc 18'),
    (00130, 25, 'Desc 19'),
    (00130, 28, 'Desc 20'),
    (00130, 30, 'Desc 21'),
    (00130, 50, 'Desc 23'),
    (07053, 20, 'Desc 11'),
    (07053, 25, 'Desc 12'),
    (07053, 30, 'Desc 13'),
    (07246, 20, 'Desc 5'),
    (07246, 25, 'Desc 6'),
    (07246, 30, 'Desc 7'),
    (07246, 50, 'Desc 8'),
    (07493, 20, 'Desc 1'),
    (07493, 25, 'Desc 2'),
    (07493, 30, 'Desc 3'),
    (07493, 50, 'Desc 4')
;
17 rows affected

select ProdCode
from ProductCommissionRates
group by ProdCode
having 
  count(distinct case when CommRate in (20, 25, 30) then CommRate end) = 3
  and
  count(distinct CommRate) = 3


ProdCode


7053


Warning: Null value is eliminated by an aggregate or other SET operation.


select * from ProductCommissionRates
where ProdCode in (
  select ProdCode
  from ProductCommissionRates
  group by ProdCode
  having 
    count(distinct case when CommRate in (20, 25, 30) then CommRate end) = 3
    and
    count(distinct CommRate) = 3
)  


ProdCode
CommRate
RateDesc


7053
20
Desc 11

7053
25
Desc 12

7053
30
Desc 13


Warning: Null value is eliminated by an aggregate or other SET operation.