title: selecting zip codes issue with SQL
body: <p>I am trying to write a SQL statement to fetch City, State and zipcodes for that city and state. My query should return only one state, City and list of zipcodes. I am not sure how to write one. I am not good @ Sql. It would be great if any one can help me. </p>
  
  <p>My Table looks like</p>
  
  <blockquote>
    <p>City --------------------------State  ----------     Zipcode  ------------    County</p>
  </blockquote>
  
  <pre><code>Alpharetta        Georgia      30004         Fulton
  Alpharetta        Georgia      30005         Fulton 
  Alpharetta        Georgia      30007         Fulton  
  </code></pre>