To find duplicate values in a table, the following query will works out very well. You would need to have in what column/field are you looking for duplicate values. We filter on that column where a single/same value is repeated more than once.
The following SQL query will do the job for you:
GROUP BY column1