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?