The quality of the wine is the ultimate deciding factor in how long it will last after opening. Better quality wines can last longer, while mass-produced wines may only last a couple of days.
High-grade, single-vineyard wines with a high fill level can last for at least a week in the fridge after opening, even with a slight loss of aroma.