Difference between revisions of "Maximum"

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.

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);

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

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

SELECT id, x, y, (x+y+ABS(x-y))/2 
FROM t