This is a complex question. Some normal (say 50mm) lenses will focus that closely. In this case, provided the lens is good, the detail is limited by the number of pixels in the camera.
Now the qualifications:
1) With a high number of pixels it is difficult to hold the camera steady to make use of them.
2) A dedicated tele-macro (Nikkor 105mm for example) will allow you to remain at a distance and still get a macro shot.
3) A dedicated macro will allow very small f stops, for a great depth of field, without diffraction limiting detail.
4) Extension tubes, reversed lenses, closeup adapters all work very well. You can find full descriptions on youtube.