Selecting records in a table by attributes

There are various ways to select features in ArcMap. One way is to select features through an attribute table. From a table, you can interactively select records by pointing at them, or you can select those records that meet some criteria; for example, find all cities with a population greater than one million.

To select records using an attribute query, follow these steps:

1. Click Table Options in the table you want to query and click Select By Attributes .
2. Click the Method arrow and click the selection procedure you want to use.
3. Double-click the field from which you want to select.
4. Click the logical operator you want to use.
5. Click the Get Unique Values button, then scroll to and double-click the value you want from the Unique Values list.

   Optionally, you can type a value directly into the text box.

6. Click Verify to verify your selection.
7. Click Apply to update the selection.
8. Click Close.

Tip:

You can use a SQL WHERE clause on the Select By Attributes dialog box.

Tip:

Use Apply if you intend to run more than one query or if you want to check your results before closing the Select By Attributes dialog box.

Tip:

You can save and reload selection expressions using the Save and Load buttons at the bottom of the Select By Attributes dialog box. This lets you quickly re-create a selected set of records by loading a saved expression.

Tip:

Click Help on the Select By Attributes dialog box to learn about building a query.