Query Properties Dialog

In the Query Properties dialog you can set two properties of the SQL Query, i.e. whether to return distinct values, and whether to limit the result set.

이 λͺ…령을 μ‚¬μš©ν•˜λ €λ©΄...

In the Query Design View, choose Edit - Query Properties.


λͺ…λ£Œκ°’

Expands the created select statement of the SQL Query in the current column by the parameter DISTINCT. The consequence is that identical values occurring multiple times are listed only once.

λΌμž„

Adds a Limit to set the maximum number of records to return.