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


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



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.