/text/shared/02/querypropdlg.xhp queries; set properties Query Properties Dialog In the Query Properties dialog, set properties belong to SQL Query, that you need your current task.

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

Distinct Values Use distinct values in query. Not use distinct values in query. 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. Limit Adding a Limit to maximize the number of records to return.