Point ID Length: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 04:41, 12 February 2014
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)