MOD
From SQLZOO
| MOD(a,b) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | |
| mysql | Yes | a % b |
| oracle | Yes | |
| postgres | Yes | a % b |
| sqlserver | No | a % b |
MOD
MOD(a,b) returns the remainder when a is divied by b
If you use MOD(a, 2) you get 0 for even numbers and 1 for odd numbers.
If you use MOD(a, 10) you get the last digit of the number a.
MOD(27,2) -> 1 MOD(27,10) -> 7
With a GROUP BY region statement each region shows up just once. The SUM column gives the total for each region.
SELECT MOD(yr,10), yr, city FROM games
SELECT MOD(yr,10), yr, city FROM games
See also
