Try this:

select s.userid, s.segmentid
from segments s,
(SELECT user_id, count(user_id) from segments
WHERE typeid = 100
group by user_id
having count(user_id) > 1) b
where s.typeid = 100 and s.userid=b.userid;

I could not test this query but I think there is a good probability that this will give you the output that you are looking for.

Thanks.

Syed