Difference between revisions of "Maximum"

From SQLZOO
Jump to: navigation, search
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='ht'>
 
<div class=params>schema:scott</div>
 
<div class=params>schema:scott</div>

Revision as of 12:51, 2 August 2012

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.

schema:scott
DROP TABLE t
 CREATE TABLE t(
  id VARCHAR(10),
  x INTEGER,
  y INTEGER );
INSERT INTO t VALUES ('A',1,2);
INSERT INTO t VALUES ('B',4,3);
INSERT INTO t VALUES ('C',5,5);

The function for using MAX over two fields is

max(x,y) = (x + y + ABS(x-y))/2

The function for using MIN over two fields is

min(x,y) = (x + y - ABS(x-y))/2
SELECT id, x, y, (x+y+ABS(x-y))/2 
FROM t
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense