AnsweredAssumed Answered

Why Does Definition Query and Select by Attributes Gives Me Different Results

Question asked by kellyeallen on Jun 5, 2018
Latest reply on Jun 7, 2018 by mboeringa2010

I have created a Select by Attributes query  expression and saved it (.exp file). When I run this query as a new selection on my map layer I get 3924 selected of 11500. See below:

However, if clear my selection and then used the same saved expression as a Definition Query (By selecting the saved query in the Definition Query box)  for the same map layer I get a different number of records selected. See below:

 

After running the Definition Query I'm only getting 2000 results.

Can anyone explain why the same query on the same data set would produce different output results? 

Outcomes