Skip To Content

Select features using attributes

The Select By Attributes button Select By Attributes opens the Select Layer By Attribute geoprocessing tool to form a SQL query to select features matching a selection criteria. So instead of interactively selecting features by clicking or drawing a graphic in the map or scene, you build a query expression to generate the subset. You can query a dataset based on a field in a layer or a table.

How to select by attributes

  1. On the Map tab in the Selection group, click Select By Attributes Select By Attributes to open the Select Layer By Attribute geoprocessing tool.
    1. If you're working in a table view, under the Table tab, on the View tab, in the Selection group, click Select By Attributes Select By Attributes.
  2. Choose the layer or table name from which you want to select.
  3. Specify the Selection type to control how the selection is applied and what to do if a selection already exists in the view.
  4. Enter a query expression using one of the following methods:
    • Click Clause, then click Add Clause Add New Clause to begin building a query. Click UpdateUpdate to validate the expression.
    • Click SQL to type an expression directly. Click the Verify the SQL expression is valid button to validate the expression.
    • Click Load Load Query to load an existing query saved as a file.
  5. Click Run Run to execute the selection query and work with the selection results.
    1. Zoom to your selection by clicking the results count at the bottom of the view.
      Zoom to the selected features.
  6. Optionally, you can save the query expression for later reuse.

Related topics