http://sqlzoo.net/w/index.php?title=DIV&feed=atom&action=history 2013-05-22T00:43:01Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=DIV&diff=4229&oldid=prev 2012-10-21T20:49:08Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 20:49, 21 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 11:</td> <td colspan="2" class="diff-lineno">Line 11:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;DIV&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;DIV&lt;/h1&gt;</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&lt;p&gt;<del class="diffchange diffchange-inline">aDIVb </del>returns the integer value of a divided by b. &lt;/p&gt;</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&lt;p&gt;<ins class="diffchange diffchange-inline">&lt;b&gt;a DIV b&lt;/b&gt; </ins>returns the integer value of a divided by b. &lt;/p&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;&lt;/p&gt; &#160;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;&lt;/p&gt; &#160;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;pre style='width:60ex'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;pre style='width:60ex'&gt;</div></td></tr> </table>

Peter http://sqlzoo.net/w/index.php?title=DIV&diff=4228&oldid=prev 2012-10-21T20:47:15Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 20:47, 21 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 9:</td> <td colspan="2" class="diff-lineno">Line 9:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[FLOOR |FLOOR(a/b)]]&lt;/td&gt;&lt;/tr&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[FLOOR |FLOOR(a/b)]]&lt;/td&gt;&lt;/tr&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/table&gt;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;DIV&lt;/h1&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;h1&gt;DIV&lt;/h1&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;aDIVb returns the integer value of a divided by b. &lt;/p&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;p&gt;aDIVb returns the integer value of a divided by b. &lt;/p&gt;</div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 34:</td> <td colspan="2" class="diff-lineno">Line 35:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[MOD |MOD function]]&lt;/li&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; &lt;li&gt;[[MOD |MOD function]]&lt;/li&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/ul&gt;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Languages}}</ins></div></td></tr> </table>

Peter http://sqlzoo.net/w/index.php?title=DIV&diff=1297&oldid=prev 2012-07-16T10:36:38Z

<p></p> <table class='diff diff-contentalign-left'> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;'> <td colspan='2' style="background-color: white; color:black;">← Older revision</td> <td colspan='2' style="background-color: white; color:black;">Revision as of 10:36, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 20:</td> <td colspan="2" class="diff-lineno">Line 20:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-mysql'&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;source lang='sql' class='def e-mysql'&gt;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name,</div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; <del class="diffchange diffchange-inline">FLOOR(</del>population<del class="diffchange diffchange-inline">/</del>1000000<del class="diffchange diffchange-inline">)</del></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>&#160;&#160; &#160; &#160; population <ins class="diffchange diffchange-inline">DIV </ins>1000000</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; FROM bbc</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&#160;&#160; FROM bbc</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt;</div></td><td class='diff-marker'>&#160;</td><td style="background: #eee; color:black; font-size: smaller;"><div>&lt;/source&gt;</div></td></tr> </table>

Connor http://sqlzoo.net/w/index.php?title=DIV&diff=1296&oldid=prev 2012-07-16T10:34:19Z

<p>Created page with &quot;&lt;table align=&#039;right&#039; border=&#039;1&#039;&gt; &lt;caption&gt;Compatibility&lt;/caption&gt; &lt;tr&gt;&lt;th colspan=&#039;3&#039;&gt;a DIV b&lt;/th&gt;&lt;/tr&gt; &lt;tr&gt;&lt;td align=&#039;center&#039;&gt;&#039;&#039;&#039;Engine&#039;&#039;&#039;&lt;/td&gt;&lt;td align=&#039;center&#039;&gt;&#039;&#039;&#039;OK&#039;&#039;&#039;&lt;/td...&quot;</p> <p><b>New page</b></p><div>&lt;table align='right' border='1'&gt;<br /> &lt;caption&gt;Compatibility&lt;/caption&gt;<br /> &lt;tr&gt;&lt;th colspan='3'&gt;a DIV b&lt;/th&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='center'&gt;'''Engine'''&lt;/td&gt;&lt;td align='center'&gt;'''OK'''&lt;/td&gt;&lt;td align='center'&gt;'''Alternative'''&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;ingres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[FLOOR |FLOOR(a/b)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;mysql&lt;/td&gt;&lt;td&gt;Yes&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;oracle&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[FLOOR |FLOOR(a/b)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;postgres&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[FLOOR |FLOOR(a/b)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td align='left'&gt;sqlserver&lt;/td&gt;&lt;td&gt;No&lt;/td&gt;&lt;td&gt;[[FLOOR |FLOOR(a/b)]]&lt;/td&gt;&lt;/tr&gt;<br /> &lt;/table&gt;<br /> &lt;h1&gt;DIV&lt;/h1&gt;<br /> &lt;p&gt;aDIVb returns the integer value of a divided by b. &lt;/p&gt;<br /> &lt;p&gt;&lt;/p&gt; <br /> &lt;pre style='width:60ex'&gt;<br /> 8 DIV 3 -&gt; 2 <br /> &lt;/pre&gt;<br /> <br /> &lt;div class='ht'&gt;<br /> In this example we calculate the population in millions. <br /> &lt;source lang='sql' class='def e-mysql'&gt;<br /> SELECT name,<br /> FLOOR(population/1000000)<br /> FROM bbc<br /> &lt;/source&gt;<br /> &lt;source lang='sql' class='def'&gt;<br /> SELECT name,<br /> FLOOR(population/1000000)<br /> FROM bbc<br /> &lt;/source&gt;<br /> &lt;/div&gt;<br /> <br /> &lt;p&gt;See also&lt;/p&gt;<br /> &lt;ul&gt;<br /> &lt;li&gt;[[MOD |MOD function]]&lt;/li&gt;<br /> &lt;/ul&gt;</div>

Connor