MOD

From SQLZOO
Revision as of 09:04, 13 July 2012 by Connor (Talk | contribs) (Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>MOD(a,b)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</t...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
Compatibility
MOD(a,b)
EngineOKAlternative
ingresYes
mysqlYesa % b
oracleYes
postgresYesa % b
sqlserverNoa % 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

See also