title: SQL query to sort the ID as ASC and Zip must not dup
body: <p>I have an SQL statement like this:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT         TOP 100 id, 
                 lastname, 
                 firstname, 
                 address1, 
                 city, 
                 state, 
                 zip 
  FROM   leads 
  WHERE  id &gt; 100 
  ORDER  BY id ASC 
  </code></pre>
  
  <p>Now I want the ZIP to be different (not dup) for 100 result with 1 query statement like that.</p>