title: Ignore NULLs in ORDER BY CLAUSE
body: <p><strong>EDIT</strong>: I have changed the characters to integers to better represent my issue - not sure if it makes a difference to the actual <code>ORDER BY</code> Clause. The Original dataset can be found at the bottom of this question.</p>
  
  <p>Is it possible to <strong>ignore</strong> <code>NULLS</code> in the <code>ORDER BY CLAUSE</code>?</p>
  
  <p>I have a query which I run which currently gives me this:</p>
  
  <pre><code>COL1     COL2     COL3
  -----------------------
  111      111      100
  112      NULL     200
  113      115      100
  NULL     112      400
  NULL     114      250
  </code></pre>
  
  <p>But I want it to ORDER BY to look like this:</p>
  
  <pre><code>COL1     COL2    COL3
  -----------------------
  111      111      100
  NULL     112      400
  112      NULL     200
  NULL     114      250
  113      115      100
  </code></pre>
  
  <p>I want the ORDER BY to ignore the <code>NULLS</code> in <code>COL1</code>.
  BUT I still want it Ordered by each column.</p>
  
  <p><code>ORDER BY COL1, COL2, COL3</code></p>
  
  <hr>
  
  <p><strong>ORIGINAL DATASET</strong></p>
  
  <pre><code>COL1     COL2     COL3
  -----------------------
  111      AAA      100
  112      NULL     200
  113      EEE      100
  NULL     BBB      400
  NULL     DDD      250
  </code></pre>