Advanced Search

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

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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

You need to login to post a comment.