Advanced Search

Return to Snippet

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