Which clause should you specify with TOP queries to avoid unpredictable results?

• A. ORDER BY
• B. WHERE
• C. GROUP BY
• D. HAVING

Answer: (A)

Specify an ORDER BY with TOP to guarantee which rows are returned. TOP limits the result to a fixed number of rows, but without an explicit order, the database can pick any rows that satisfy the query, and which rows appear can vary between executions as data or plans change. By defining a stable order first, you ensure the same set of rows is returned each time (assuming the underlying data hasn’t changed). Use a deterministic ordering key, and add a secondary key to break ties if needed to avoid ambiguity. In Marketing Cloud SQL-like queries, this is essential to prevent unpredictable results. The other clauses filter or aggregate data but don’t determine the return order, so they don’t resolve the randomness on their own.