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

Revision: 49631

at July 27, 2011 02:42 by ariellephan

Updated Code

SELECT Left( ZIPCODE, 3 ) AS ZIP, Count( left( ZIPCODE, 3 ) ) AS QUANTITY
FROM `tblusstatezip`
GROUP BY Left( ZIPCODE, 3 )
ORDER BY `ZIPCODE` ASC
LIMIT 0 , 30

Revision: 49630

at July 27, 2011 02:40 by ariellephan

Initial Code

SELECT Left( ZIPCODE, 3 ) AS ZIP, Count( left( ZIPCODE, 3 ) ) AS QUANTITY
FROM `tblusstatezip`
GROUP BY Left( ZIPCODE, 3 )
LIMIT 30 , 300

Initial URL

Initial Description

Initial Title

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

Initial Tags

Initial Language

SQL

Choose a language for easy browsing: