Does SIP actually work?

SIP is the most popular and  recommended mode of investment, however, does SIP investing work always and for everyone?