Which is better: Internal or external motivation?

Is it better to be motivated by a reward? Or for the sake of accomplishing a goal?