Tag Archives: duplicate

Find duplicate values in database table

Description: Detect fields that have duplicate values in a database table. Solution: For finding duplicate values, the COUNT condition can be used, specifying the column name that we require. Example: SELECT customer_idFROM customers_tableGROUP BY┬ácustomer_idHAVING count( * ) > 1; Also … Continue reading

Posted in SQL | Tagged , | Leave a comment