How long does a bottle of wine last if not opened and not refrigerated?

How about champagne? How long does it last refrigerated and not refrigerated? Thanks.
7 answers 7