You asked

Is the sony rx100 good in low light?

Here is what the site says about that.

From Sony RX100: Sony RX100: A fixed-lens compact by Sony with a 20.2-megapixel 1-inch sensor, announced in 2012. The original one-inch pocket compact. Specs - Maker: Sony - Lens: built in, 10-37mm f/1.8-4.9 - Sensor: 1-inch, 13.2 x 8.8mm, crop factor 2.7 - Resolution: 20.2 megapixels - Stabilisation: in the built-in lens or the body - Announced: 2012 - Type: fixed-lens compact Focal lengths on it Its 10-37mm lens frames like 28-100mm on full frame, ...

From Sony a7S III: Sony a7S III: A mirrorless camera by Sony with a 12.1-megapixel full frame sensor, announced in 2020. Built for video and low light; 12 megapixels is little for stills.

Quoted from this site's pages.

From these pages