漏洞
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.
| 漏洞 ID 编号 | BUG-000108625 |
|---|---|
| 已提交 | October 9, 2017 |
| 上次修改时间 | June 5, 2024 |
| 适用范围 | ArcGIS for Desktop |
| 找到的版本 | 10.3.1 |
| 操作系统 | N/A |
| 操作系统版本 | N/A |
| 状态 | Will Not Be Addressed |
附加信息
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.解决办法
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.
重现步骤
漏洞 ID: BUG-000108625
软件:
- ArcGIS for Desktop
当漏洞状态发生变化时获得通知
发现关于本主题的更多内容
搜索相关信息
查找与此主题相关的培训
探索想法并提供反馈
获取来自 ArcGIS 专家的帮助
下载 Esri 支持应用程序