Copy Query and Syntax:

Query: Identify duplicate records in Location Column using Group By Clause
Syntax: Select Location from Sales group by Location having Count(*) > 1