Programming

select T_ADDRESS, T_MCC,T_MNC,T_MSIN,T_IM_MNC, COUNT(*) FROM TABLETEST 
WHERE T_MCC=123 AND (T_MNC=11 OR T_MNC=01)
GROUP BY T_ADDRESS,T_MCC,T_MNC,T_MSIN,T_IM_MNC HAVING count(*) > 5;

 T_ADDRESS         T_MCC   T_MNC   T_MSIN   T_IM_MNC                 
 32011111111             123          11           1234567890    01                         7   
 32711111111             123          11           1234567890    02                         7   
 32911111111             123          11          1234567890     03                       13

select T_ADDRESS, T_MCC,T_MNC,T_MSIN,T_IM_MNC, COUNT(*) 
FROM TABLETEST  WHERE T_MCC=123 AND (T_MNC=11 OR T_MNC=01) 
GROUP BY T_ADDRESS,T_MCC,T_MNC,T_MSIN,T_IM_MNC 
HAVING (count(*) > 5 and T_IM_MNC=01) or count(*) > 5 and T_IM_MNC=02) );

...
HAVING COUNT(*) > CASE T_IM_MNC
 WHEN 1 THEN 5
 WHEN 2 THEN 3
 ELSE        7 END

For example:
T_IM_MNC=01 => HAVING count(*) > 5
T_IM_MNC=02 => HAVING count(*) > 3
T_IM_MNC=03 => HAVING count(*) > 7

HAVING count(*) > CASE
 WHEN T_IM_MNC=01 THEN 5
 WHEN T_IM_MNC=02 THEN 3
 WHEN T_IM_MNC=03 THEN 7
 END

HAVING count(*) > CASE
WHEN T_IM_MNC=01
THEN 5
WHEN T_IM_MNC=02
THEN 3
ELSE 7
END

HAVING count(*) > CASE T_IM_MNC
 WHEN 01
     THEN 5
 WHEN 02
     THEN 3
 ELSE     7
 END