What does % in this WHERE clause do?
It is being used as a Modulo Operator; returning the remainder of a number divided by another to solve sql server modulo. In your example, the WHERE clause is limiting the results to only those where the Col1 value divided by 3 leaves a remainder of 1. (e.g. 4,7,10, etc.) Hope this help you solve sql server modulo…
Answered Sep 9, 2021 · 1.1K Views Read answer →