title: Subtracting minimum value from all values in a column
body: <p>Is there a another way to subtract the smallest value from all the values of a column, effectively offset the values?</p>
  
  <p>The only way I have found becomes horribly complicated for more complex queries.</p>
  
  <pre><code>CREATE TABLE offsettest(value NUMBER);
  INSERT INTO offsettest VALUES(100);
  INSERT INTO offsettest VALUES(200);
  INSERT INTO offsettest VALUES(300);
  INSERT INTO offsettest VALUES(400);
  
  SELECT value - (SELECT MIN(value) FROM offsettest) FROM offsettest;
  
  DROP TABLE offsettest;
  </code></pre>
  
  <p>I'd like to limit it to a single query (no stored procedures, variables, etc) if possible and standard SQL is preferred (although I am using Oracle).</p>