Opposition leader Michael Sata has won Zambia's presidential election after two days of vote counting following a tight race with incumbent Rupiah Banda.