Select a range of numerical values using the Select By Attributes tool in ArcGIS Pro

Summary

When querying, exploring, analyzing, or editing data, selecting features can be used to identify or work with a subset of features on the map. Selecting features to calculate statistics, view attributes, or edit the set of features that make up a map layer is done by applying a selection.

The instructions demonstrate how to use the ArcGIS Pro Select By Attributes geoprocessing tool to identify a specific range of attribute fields for further analysis. In this example, the LEVEL_NO field in the Schools_all feature class is used to identify the attribute fields within the range of 2 to 4.

Procedure

1. Start ArcGIS Pro and open the project.
2. In the Contents pane, right-click the feature class and click Attribute Table to open the attribute table.

3. In the feature class attribute table, click Select By Attributes to open the Select By Attribute geoprocessing tool.

4. In the Select By Attributes tool dialog box, configure the following parameters.
   1. For Selection type, click the drop-down menu and select New selection.
   2. Enter the query expression in Clause mode or SQL mode.

Note:
By default, the query builder is in Clause mode. Toggle the SQL option  to open it in SQL mode.

• For Clause mode:

Where <field name> is greater than or equal to <field value> AND <field name> is less than or equal to <field value>

• For SQL mode:

<field name> BETWEEN <field value> AND <field value>

3. Click the Verify button to validate the expression.
4. Click OK.