Point ID Length: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | This query groups PointID on LENGTH. If length is 0, 1, or 2 the values should be looked into. | ||
<pre> | |||
SELECT | |||
Count(geopoint_guid), | Count(geopoint_guid), | ||
length(pointlocal_id) | length(pointlocal_id) | ||
Revision as of 17:00, 11 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)