Different values appear in Select by Attributes get unique values window then seen in the table when using field type 'Double'.
Last Published: January 5, 2015ArcGIS for Desktop
Bug ID Number
October 16, 2014
March 30, 2022
ArcGIS for Desktop
Will Not Be Addressed
The development team has considered the issue or request and concluded it will not be addressed. The issue's Additional Information section may contain further explanation.
Although not visually pleasing, the select by attributes is actually reporting the more accurate value for what is actually stored in the data.
Workaround done in shapefile format by creating new field and specifying scale and precision then using field calculator to bring over values from old field to new field removes the extra digits in the select by attributes window.