Is the revolver the only one to spin its chamber?

Revolvers have a CYLINDER that spins. And yes, single or double shot pistols, and automatic pistols do not have a cylinder- so there is nothing to spin, rotate or revolve.

There were a couple of two or more shot pistols that were developed before the development of the revolver that twisted or spun barrels to fire multiple shots. More often than not, firing a single shot from most of these would fire all barrels, and more often than not would cause the weapon to explode, injuring or killing the shooter.