Try the following statement:

SELECT b.segmentid, b.user_id, count(b.user_id) from segments b
WHERE b.typeid = 100
group by b.segmentid, b.user_id
having count(b.user_id) > 1