Sometime we just want to find any duplicate data in the table, this simple statement will help to get the list of duplicate data.
SELECT field1, field2, COUNT(*)
FROM
tableName
GROUP BY
field3
HAVING
COUNT(*) > 1
SQL Statement to find duplicate data
1 min read
Latest from Blog
Sometimes the VestaCP SSL Certificate didn’t get auto-renew, so you might need to run the command
VestaCP released the new version 1.0, but it contains a lot of bugs that caused Letsencrypt
An aero wheelset is one of the fastest upgrades for your bike. In this video I’ll
An aero wheelset is one of the fastest upgrades for your bike. In this video, I’ll
Wondering whether worth buying China-made Carbon Wheelsets? After setting up the new Winspace Hyper wheelsets, I