A system exhibits zero viscosity when its particles condense into a single quantum mechanical state. Superconductivity is an instance of this, where electrons pair up and flow without resistance.
Buckets of liquid helium show superfluidity. [1]
Labs cool blobs of alkali gas to superfluidity. [2]
Entire cores of neutron stars are superfluid. [3]
There's even a theory of quantum gravity where physical vacuum is a superfluid. [4]
[1] https://www.youtube.com/watch?v=2Z6UJbwxBZI
[2] https://www.youtube.com/watch?v=1RpLOKqTcSk