Difference between revisions of "MOD"

From SQLZOO
Jump to: navigation, search
Line 20: Line 20:
 
<div class='qu'>
 
<div class='qu'>
 
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 e-sqlserver'>SELECT yr % 10,
+
<source lang='sql' class='def e-sqlserver'>SELECT yr % 10, yr, city
      yr, city
+
FROM games
  FROM games
+
 
</source>
 
</source>
<source lang='sql' class='def'>
+
<source lang='sql' class='def'>SELECT MOD(yr,10),
SELECT MOD(yr,10),
+
 
       yr, city
 
       yr, city
 
   FROM games
 
   FROM games
 
</source>
 
</source>
 
</div>
 
 
<p>See also</p>
 
<p>See also</p>
 
<ul>
 
<ul>

Revision as of 10:20, 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 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