MAX - Revision history

Peter at 20:45, 22 October 2012

2012-10-22T20:45:53Z

2012-08-05T01:34:23Z

2012-07-13T11:35:38Z

2012-07-13T10:54:16Z

2012-07-13T08:53:49Z

2012-07-13T08:53:35Z

2012-07-13T08:46:28Z

2012-07-13T08:41:47Z

Compatibility
Engine	OK	Alternative
2012-07-12T16:05:28Z Created page with "<h3>MAX</h3> <table align='right' border='1'> <caption>Compatibility</caption> <caption>ABS(f)</caption> <tr><th>Engine</th><th>OK</th><th>Alternative</th></tr> <tr><td align=..." New page <h3>MAX</h3> <table align='right' border='1'> <caption>Compatibility</caption> <caption>ABS(f)</caption> <tr><th>Engine</th><th>OK</th><th>Alternative</th></tr> <tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr> <tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr> <tr><td align='left'>postgres</td><td>No</td><td>[[d+ i]]</td></tr> <tr><td align='left'>sqlserver</td><td>No</td><td>[[d+ i]]</td></tr> </table> <p>MAX finds the highest values in a column or part of a column</p> <p>MAX is an aggregate function it is normally used with GROUP BY.</p> <pre style='width:50ex'> SELECT region, MAX(name) FROM bbc GROUP BY region </pre> <div class='qu'> With a <code>GROUP BY</code> <code>region</code> statement each region shows up just once. The MAX column gives the "largest" name in the region in the context of strings this is the last name alphabetically. <source lang='sql' class='def'> SELECT region, MAX(name) FROM bbc GROUP BY region </source> <source lang='sql' class='ans'> SELECT region, MAX(name) FROM bbc GROUP BY region </source> </div> <p>See also</p> <ul> <li>[[EXTRACT function]]</li> <li>[[SUM function]]</li> <li>[[MIN function]]</li> </ul>

@@ Line 30: / Line 30: @@
 <p>See also</p>
 <ul>
-   <li>[[EXTRACT function]]</li>
+   <li>[[EXTRACT |EXTRACT function]]</li>
-   <li>[http://sqlzoo.net/w/index.php/SUM SUM function]</li>
+   <li>[[SUM |SUM function]]</li>
-   <li>[http://sqlzoo.net/w/index.php/MIN MIN function]</li>
+   <li>[[MIN |MIN function]]</li>
 </ul>

@@ Line 39: / Line 39: @@
 <ul>
    <li>[[EXTRACT function]]</li>
-   <li>[[SUM function]]</li>
+   <li>[http://sqlzoo.net/w/index.php/SUM SUM function]</li>
    <li>[http://sqlzoo.net/w/index.php/MIN MIN function]</li>
 </ul>

@@ Line 9: / Line 9: @@
 <tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr>
 </table>
 <p>MAX finds the highest values in a column or part of a column</p>
 <p>MAX is an aggregate function it is normally used with GROUP BY.</p>

@@ Line 25: / Line 25: @@
    FROM bbc
   GROUP BY region
 </source>
 </div>

@@ Line 2: / Line 2: @@
 <table align='right' border='1'>
 <caption>Compatibility</caption>
-<caption>ABS(f)</caption>
+<tr><th colspan='3'>MAX(f)</th></tr>
-<tr><th>Engine</th><th>OK</th><th>Alternative</th></tr>
+<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr>
-<tr><td align='left'>mysql</td><td>Yes</td><td>[[d+ i]]</td></tr>
+<tr><td align='left'>ingres</td><td>Yes</td><td></td></tr>
-<tr><td align='left'>oracle</td><td>No</td><td>[[d+ i]]</td></tr>
+<tr><td align='left'>mysql</td><td>Yes</td><td></td></tr>
-<tr><td align='left'>postgres</td><td>No</td><td>[[d+ i]]</td></tr>
+<tr><td align='left'>oracle</td><td>Yes</td><td></td></tr>
-<tr><td align='left'>sqlserver</td><td>No</td><td>[[d+ i]]</td></tr>
+<tr><td align='left'>postgres</td><td>Yes</td><td></td></tr>
 </table>
 <p>MAX finds the highest values in a column or part of a column</p>