A QueryPlus user reported getting duplicate rows in a query using this set of fields:

Which resulted in an output that looked like this: (grouped by Policy Number)

Normally, duplicated rows in QueryPlus – or any SQL query, for that matter – are the result of querying data on multiple levels.

For instance, an Invoice can have multiple Invoice Transactions, so a query with Invoice fields that also has Invoice Transaction fields in it will cause the Invoice fields to be repeated for each Invoice Transaction field.  

In this case, it is the field Policy Transaction Type that is causing those duplicates, and the reason is that while it is logical and reasonable to parse that field as 

       Policy – Transaction Type

 it is actually
 
      Policy Transaction – Type.

So query is returning multiples for any Policy that has multiple Policy Transactions. (I know that field name is confusing, and I apologize for that, but unfortunately we’re stuck with it.) 

The good news is that there is a Policy-level field that will give the same information (Policy – Transaction Type), but without the duplicates: 

       Policy Basic Transaction Type 

This field looks at all the Types of all the Transactions for a Policy, and returns either NBS or RWL, depending on which of these it finds (in some rare cases, there is neither of those Types, so the field is blank). 

So by replacing the Policy Transaction Type field with Policy Basic Transaction Type, your query will lose those annoying duplicates.