% (Modulo) in SQL Server

Provides the remainder of one number divided by another.

Syntax:-

dividend % divisor


Example:-