Query options
Multiple query options can be set in a Query section to modify the results returned from a query. The Query Properties window, as shown in the following screenshot, is opened by double-clicking the word Request in the Request line, or by clicking on the Query menu and selecting Query Options:
The commonly used features of this window are the Process options contained in the Process box. The following is a breakdown of each Process property:
The Return Unique Rows option is used to pull back a distinct list of values for the defined query.
The Return First property limits the results returned from a query to a subset of rows. This feature is usually used to sample output from a query. Once the limit has been reached, a dialogue box will appear notifying the user that the query has reached the desired limit and will display the results returned from the query up to the row limit.
The Time Limit property limits the amount of time a query is allowed to run in minutes. This...
