Modulo Operator (%)
Returns remainder after division.
sql
1SELECT 10 % 3; -- Returns: 1
2SELECT 15 % 4; -- Returns: 3Use Cases
- Check even/odd numbers
- Cyclic patterns
- Grouping by intervals
Returns remainder after division.
1SELECT 10 % 3; -- Returns: 1
2SELECT 15 % 4; -- Returns: 3