advanced code snippet search

Posted By

ariellephan on 07/27/11


Tagged

zipcodes


Versions (?)

Select Zipcodes group by the first 3 digits and Export in Set

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT LEFT( ZIPCODE, 3 ) AS ZIP, Count( LEFT( ZIPCODE, 3 ) ) AS QUANTITY
  2. FROM `tblusstatezip`
  3. GROUP BY LEFT( ZIPCODE, 3 )
  4. ORDER BY `ZIPCODE` ASC
  5. LIMIT 0 , 30

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: ariellephan on July 27, 2011

Formatted

You need to login to post a comment.