My Sony a65 has a 24MP and 10MP mode. Will shooting at 10MP result in less image noise? I'm looking to do more night photography.
Yes, but don't do it that way. It will take the whole image and re-size it before it is saved to disk. This will reduce the noise, but it is an irreversible operation that can be better done on your computer. Save the RAW file and convert on your computer. If you are not satisfied with the noise consider options such as image stacking.