How do I control query options (number of rows, etc.)?
When viewing your query in the Query panel, you can use the Properties button to select just a sample data set, opt not to retrieve duplicates, alter the order of prompts, and control other options about the query itself. (see below)