How does duplicate Google Analytics tracking code affect a site?

The consequences of having two Google Analytics scripts, especially if they are pointing to the same UA-ID, is that you'll end up double counting pageviews, visits, etc. Do you have the option of removing one? If so, do that.