Difference between revisions of "MOD"

From SQLZOO
Jump to: navigation, search
(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...")
 
Line 21: Line 21:
 
With a <code>GROUP BY region</code> statement each region shows up just once. The SUM column gives the total for each region.   
 
With a <code>GROUP BY region</code> statement each region shows up just once. The SUM column gives the total for each region.   
 
<source lang='sql' class='def'>
 
<source lang='sql' class='def'>
 +
SELECT MOD(yr,10),
 +
      yr, city
 +
  FROM games
 +
</source>
 +
<source lang='sql' class='def e-sqlserver'>
 
SELECT MOD(yr,10),
 
SELECT MOD(yr,10),
 
       yr, city
 
       yr, city

Revision as of 09:06, 13 July 2012

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
SELECT MOD(yr,10),
       yr, city
  FROM games

See also

Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense