Working with Modulo operator.

Modulo operator provides the remainder of one number divided by another number.

Syntax:-

dividend % divisor

Where,Dividend is the numeric expression to divide. Dividend must be any expression of integer data type in Sql Server.

Divisor is the numeric expression to divide the dividend. Divisor must be expression of integer data type except in Sql Server.

Example:-

SELECT 15%2;

Output
1