SQL query statement to find duplicate records in a database table. SELECT fieldname1, fieldname2, COUNT(duplicatefieldname) FROM tablename GROUP BY duplicatefieldname HAVING COUNT(duplicatefieldname)
Read More »
Sometime we just want to find any duplicate data in the table, this simple statement will help to get the list of
Read More »
A simple statement to update one table field with another table field value. UPDATE theUpdateTable INNER JOIN theValueTable ON (theUpdateTable.matchValueField =theValueTable.matchValueField) SETtheUpdateTable.valueToUpdate
Read More »