In general, an oil-based deck stain will last the longest, but it also depends on the type of wood, the weather conditions, and how long the deck has gone unprotected before staining.