Q:

I'm looking for the sql term to remove duplicate rows from a report

The adhoc report tool is a Shazam product and I have a sql filter that has these value options: 
Is Equal To
Is Between
Is Greater Than
Is Greater or Equal 
Is Less Than 
Is Less or Equal To 
Is Like
Is Not Equal To 
Is Not Between 
Is Not Like 

The report runs, but I have a couple duplicates of the same Incident Number.  How can I tell it to remove any duplicates? 

A:

I think you are looking for the DISTINCT clause:

The SQL DISTINCT command used along with the SELECT keyword retrieves only unique data entries depending on the column list you have specified after it. 

