Maximum - Revision history

Connor at 15:04, 2 August 2012

2012-08-02T15:04:03Z

2012-08-02T11:51:47Z

2012-07-30T14:06:45Z

2012-07-30T13:59:29Z

2012-07-30T13:57:52Z

@@ Line 21: / Line 21: @@
 <div class="ecomm e-mysql" style="display: none">In MySQL you can also use the <code>GREATEST</code> or <code>LEAST</code> functions to do this.</div>
 <div class="ecomm e-oracle" style="display: none">In Oracle you can also use the <code>GREATEST</code> or <code>LEAST</code> functions to do this.</div>
 {{Hacks Ref}}

@@ Line 17: / Line 17: @@
   min(x,y) = (x + y - ABS(x-y))/2
 </div>
-<source lang='sql' class='def'>SELECT id, x, y, (x+y+ABS(x-y))/2
+<source lang='sql' class='def'>
-FROM t</source>
+SELECT id, x, y, (x+y+ABS(x-y))/2
 <div class="ecomm e-mysql" style="display: none">In MySQL you can also use the <code>GREATEST</code> or <code>LEAST</code> functions to do this.</div>
 <div class="ecomm e-oracle" style="display: none">In Oracle you can also use the <code>GREATEST</code> or <code>LEAST</code> functions to do this.</div>

@@ Line 1: / Line 1: @@
-Calculate the maximum or minimum of two fields
+In this example you are shows how to use the MAX or MIN functions to find the maximum or minimum over two fields instead of just one.
 <div class='ht'>
 <div class=params>schema:scott</div>

@@ Line 12: / Line 12: @@
 </source>
 <div>
-<p>The function for using MAX over two fields is</p>
+<p>The function for using <code>MAX</code> over two fields is</p>
   max(x,y) = (x + y + ABS(x-y))/2
-<p>The function for using MIN over two fields is</p>
+<p>The function for using <code>MIN</code> over two fields is</p>
   min(x,y) = (x + y - ABS(x-y))/2
 </div>
 <source lang='sql' class='def'>SELECT id, x, y, (x+y+ABS(x-y))/2
 FROM t</source>
-<div class="ecomm e-mysql" style="display: none">In MySQL you can also use the GREATEST or LEAST functions to do this.</div>
+<div class="ecomm e-mysql" style="display: none">In MySQL you can also use the <code>GREATEST</code> or <code>LEAST</code> functions to do this.</div>
-<div class="ecomm e-oracle" style="display: none">In Oracle you can also use the GREATEST or LEAST functions to do this.</div>
+<div class="ecomm e-oracle" style="display: none">In Oracle you can also use the <code>GREATEST</code> or <code>LEAST</code> functions to do this.</div>
 {{Hacks Ref}}