title: Oracle query for selecting sampling of number values from a table
body: <p>I have a data field in my Oracle DB Table whose datatype is NUMBER. I have tried a query below using order by.</p>
  
  <pre><code>SELECT Value
    FROM Table
   ORDER BY value;
  </code></pre>
  
  <p>I am getting the result as </p>
  
  <pre><code>Value |
  ------|
  1     |
  1     |
  2     |
  2     |
  3     |
  3     |
  4     |
  4     |
  5     |
  5     |
  6     |
  6     |
  </code></pre>
  
  <p>Instead I want a result as </p>
  
  <pre><code>Value |
  ------|
  1     |
  2     |
  3     |
  4     |
  5     |
  6     |
  1     |
  2     |
  3     |
  4     |
  5     |
  6     |
  </code></pre>