AVG - Revision history

http://www.sqlzoo.net/w/index.php?title=AVG&feed=atom&action=history AVG - Revision history 2013-05-25T07:02:01Z Revision history for this page on the wiki MediaWiki 1.20.4 http://www.sqlzoo.net/w/index.php?title=AVG&diff=4017&oldid=prev Peter at 16:54, 8 September 2012 2012-09-08T16:54:57Z

<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 16:54, 8 September 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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr> <tr><td colspan="2"> </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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>AVG</h1></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h1>AVG</h1></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>AVG gives the average (the mean) of a whole column or a group of rows for a single column of values.</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>AVG gives the average (the mean) of a whole column or a group of rows for a single column of values.</p></div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 29:</td> <td colspan="2" class="diff-lineno">Line 30:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr> <tr><td colspan="2"> </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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 35:</td> <td colspan="2" class="diff-lineno">Line 37:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[MIN |MIN function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[MIN |MIN function]]</li></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr> <tr><td colspan="2"> </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"> </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://www.sqlzoo.net/w/index.php?title=AVG&diff=1189&oldid=prev Connor at 11:37, 13 July 2012 2012-07-13T11:37:43Z

<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 11:37, 13 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 31:</td> <td colspan="2" class="diff-lineno">Line 31:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[<del class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/</del>MAX MAX function]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[<ins class="diffchange diffchange-inline">[</ins>MAX <ins class="diffchange diffchange-inline">|</ins>MAX function<ins class="diffchange diffchange-inline">]</ins>]</li></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[<del class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/</del>COUNT COUNT function]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[<ins class="diffchange diffchange-inline">[</ins>COUNT <ins class="diffchange diffchange-inline">|</ins>COUNT function<ins class="diffchange diffchange-inline">]</ins>]</li></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[<del class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/</del>MIN MIN function]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[<ins class="diffchange diffchange-inline">[</ins>MIN <ins class="diffchange diffchange-inline">|</ins>MIN function<ins class="diffchange diffchange-inline">]</ins>]</li></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=AVG&diff=1167&oldid=prev Connor at 10:53, 13 July 2012 2012-07-13T10:53:10Z

<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:53, 13 July 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'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><<del class="diffchange diffchange-inline">h3</del>>AVG</<del class="diffchange diffchange-inline">h3</del>></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><<ins class="diffchange diffchange-inline">h1</ins>>AVG</<ins class="diffchange diffchange-inline">h1</ins>></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>AVG gives the average (the mean) of a whole column or a group of rows for a single column of values.</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>AVG gives the average (the mean) of a whole column or a group of rows for a single column of values.</p></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>AVG is an aggregate function it is normally used with GROUP BY.</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>AVG is an aggregate function it is normally used with GROUP BY.</p></div></td></tr> <tr><td colspan="2" class="diff-lineno">Line 32:</td> <td colspan="2" class="diff-lineno">Line 32:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[http://sqlzoo.net/w/index.php/MAX MAX function]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[http://sqlzoo.net/w/index.php/MAX MAX function]</li></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[<del class="diffchange diffchange-inline">[</del>COUNT function<del class="diffchange diffchange-inline">]</del>]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[<ins class="diffchange diffchange-inline">http://sqlzoo.net/w/index.php/COUNT </ins>COUNT function]</li></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[http://sqlzoo.net/w/index.php/MIN MIN function]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[http://sqlzoo.net/w/index.php/MIN MIN function]</li></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr> </table>

Connor http://www.sqlzoo.net/w/index.php?title=AVG&diff=1139&oldid=prev Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>AVG(f)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td>..." 2012-07-13T08:57:33Z

<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>AVG(f)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td>..."</p> <p><b>New page</b></p><div><table align='right' border='1'><br /> <caption>Compatibility</caption><br /> <tr><th colspan='3'>AVG(f)</th></tr><br /> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br /> <tr><td align='left'>ingres</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>mysql</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>oracle</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>postgres</td><td>Yes</td><td></td></tr><br /> <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr><br /> </table><br /> <h3>AVG</h3><br /> <p>AVG gives the average (the mean) of a whole column or a group of rows for a single column of values.</p><br /> <p>AVG is an aggregate function it is normally used with GROUP BY.</p><br /> <p>The mean of the values 2, 5, 5 is (2+5+5)/3 = 12/3 = 4, you divide by 3 because there are 3 numbers in this example.</p><br /> <p>NULL values do not contribute to the calculation.</p><br /> <pre style='width:60ex'><br /> SELECT region, AVG(population)<br /> FROM bbc<br /> GROUP BY region <br /> </pre><br /> <br /> <div class='qu'><br /> With a <code>GROUP BY region</code> statement each region shows up just once. <br /> The AVG column gives the average population per country for each region. <br /> <source lang='sql' class='def'><br /> SELECT region, AVG(population)<br /> FROM bbc<br /> GROUP BY region<br /> </source><br /> </div><br /> <p>See also</p><br /> <ul><br /> <li>[http://sqlzoo.net/w/index.php/MAX MAX function]</li><br /> <li>[[COUNT function]]</li><br /> <li>[http://sqlzoo.net/w/index.php/MIN MIN function]</li><br /> </ul></div>

Connor