About 1/4, 1/3 and 1/6 inch sensors. That doesn't tell much at all since you don't know how many pixels are in the sensors and what sensitivity they give.
Instead, look to sites like dvspot.com that have example video and compare.
Be aware that few if not all of today's consumer cameras do not fare well in low light. Also, at NTSC/PAL linecounts, people misundestand that these are video cameras and not photo cameras.
3CCD is definitely better than 1CCD.
But I am in a dilemma that but how to compare these along with resolutions? I have an option between 1/3? 1CCD and 1/6? 3CCD which one is better? Other option is between 1/3? 1CCD and 1/4.7? 3CCD which one is better? Please help me to select an option. Thanks in advance.