Select multiple values using Select Layer By Attribute in ArcGIS Pro

Summary

Some workflows require selecting certain values on the map based on specific attributes. ArcGIS Pro provides the capability to select multiple features using the Select Layer By Attribute tool.

This article demonstrates the workflow by selecting multiple fire hydrant point features made by specific manufacturers in a neighborhood.

Procedure

1. Click Select By Attributes on the Map ribbon tab.
2. Configure the Select Layer By Attribute pane as follows:
   1. Select the feature layer for the Input Rows field. In this example, the Water_Hydrants layer is selected.
   2. Select New selection from the drop-down in the Selection type field.
   3. Click the New expression icon to open the query builder.

Note: 
The query builder opens in the Clause mode by default. To open it in SQL mode, toggle the SQL option . Refer to ArcGIS Pro: Query builder for more information.

4. Insert the appropriate query to select the first value.

For Clause mode, insert:

Where '<Field>' 'is equal to' '<Value>'

For SQL mode, insert:

<FIELD> = '<Value>'

In this example, the fire hydrants manufactured by Clow Corporation are selected. Use the appropriate query.

For Clause mode, insert:

Where 'Manufacturer' 'is equal to' 'Clow Corporation'

For SQL mode, insert:

MANUFACTURER = 'Clow Corporation'

5. Click the Add Clause icon to add an additional clause.
6. Insert the appropriate query to select the second value. In this example, fire hydrants manufactured by Correy are selected.

For Clause mode, insert:

'Or' 'Manufacturer' 'is equal to' 'Correy'

For SQL mode, insert:

Or MANUFACTURER = 'Correy'

Note: 
Optionally, repeat Steps 2(e) through 2(f) to select additional values if necessary.

The image below shows the queries configured in this example.

7. Click Run. The values from the queries are selected in the map.

The map shows the fire hydrants manufactured by Clow Corporation, Correy, and by unknown manufacturers selected.