Could relationships without much sex still last?

Sometimes sooner or later, the frequency of sex in a relationship wanes no matter what. Once this happens, what would make a couple, married or unmarried decide to keep the relationship. Would there be compromises made if one of the party is still very sexually active and the other not so much? What are some scenarios where a couple stayed together with little sex between them. How could they have pulled it off and why?