Bug
The Table Select tool produces inaccurate results when using the subquery GROUP BY clause with an input table that has several unique numeric values in the field to be grouped.
| Bug ID Number | BUG-000108625 |
|---|---|
| Submitted | October 9, 2017 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.3.1 |
| Operating System | N/A |
| Operating System Version | N/A |
| Status | Will Not Be Addressed |
Additional Information
A where clause query with the provided syntax is not expected to return a result for the Table Select tool that contains the max value per GROUP BY, rather all rows whose value of WATER are the maximum in any group.Workaround
Use the Summary Statistics geoprocessing tool or open the table, right-click the GROUP BY field and select Summarize. This creates a table containing one record for each unique value of the selected field (the GROUP BY field), along with statistics for any of the other fields as designated.
Steps to Reproduce
Bug ID: BUG-000108625
Software:
- ArcGIS for Desktop
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App