Greece qualified for a major tournament for only the second time in their history, a 1-0 defeat of Northern Ireland enough to win the group and consign Spain to the ignominy of the play-offs.
The Spaniards won 4-0 in Armenia with two goals from Jose Antonio Reyes in three minutes and one each from Raul and Juan Valeron.
Latvia secured their best ever finish since gaining independence with second place and a play-off berth after a 1-0 win in Stockholm.
Sweden had already done enough to win the group and they lost their first game of the campaign with Maris Verpakovskis netting the only goal of the campaign in the 23rd minute.
The visitors lost Dzintars Zirnis to a red card in the second half but held on to take the win.
The result rendered the meeting between Hungary and Poland, who both harboured play-off ambitions this weekend, meaningless.
Andrzeg Niedzieland scored twice as the Poles won 2-1 in Budapest.
Denmark had Everton midfielder Thomas Gravesen sent off in stoppage time and could only draw 1-1 with Bosnia but still won Group Two.
Norway completed a Scandinavian one two ahead of Romania by beating Luxembourg one nil with a goal from Tore Andre Flo.
The Czech Republic's trip to Austria had little riding on it as they had already won group three with Holland guaranteed second place.
Nevertheless there were still five goals and the sending-off of Markus Schopp in the game won 3-2 by the Czechs thanks to Jan Koller's goal in stoppage time.