title: How to remove duplicate values without using DISTINCT in SQL?
body: <p>I have a temp table with one column:</p>
  
  <pre><code>OfficeID
  -----
  0
  1
  1
  1
  60
  60
  61
  61
  61
  61
  317
  317  &lt;----
  63   &lt;----
  63
  63
  63
  63
  </code></pre>
  
  <p>When I am using <code>Distinct</code> to remove duplicate values, SQL orders the result as shown below, but I don't want it to be sorted.</p>
  
  <pre><code>OfficeID
  --------
      0
      1
      60
      61
      63      &lt;---
      317     &lt;---
  </code></pre>
  
  <p>I want this result without duplicate values and without being sorted</p>
  
  <pre><code>OfficeID
  ----------
      0
      1
      60
      61
      317    &lt;---
      63     &lt;---
  </code></pre>