Point ID Length

From IMSMA Wiki
Revision as of 17:00, 11 February 2014 by Alnaucler (talk | contribs)
Jump to navigation Jump to search

This query groups PointID on LENGTH. If length is 0, 1, or 2 the values should be looked into.

SELECT
Count(geopoint_guid),
length(pointlocal_id)
FROM
geopoint
GROUP BY
length(pointlocal_id)
ORDER by length(pointlocal_id)