ArcGIS Desktop

  • Documentation
  • Support

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

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 Table Options in the table you want to query and click Select By Attributes 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.

Related topics

  • Understanding how to find and view records in tables

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2018 Esri. | Privacy | Legal