Hi Sagar, thanks for your comment. With your query, it will delete duplicate data including original data also. But we need only duplicate data to get removed. There are several ways to get the same result. I had showed the one, there are many other simple ways too which can be used.
Hi, thanks for your comment. Table doesn't exist means there is no existing table. So, first need to create the table with same structure which is used in the session and next we need to execute CTE and next query together to perform the deletion..
I really loved to watch this session of fetching and removing duplicate records. Thank you vaia.
It's really amazing to see you even covering small details. Thank you.
So nice of you
Very nice explain sir
❤❤ thanks
Awesome explain
great Sir
without using aggregate function how we can use group by clause
it should give error
Can we execute the beloq query?
Delete from person
Where email in(select email from person group by email
Having count(email)>1)
Hi Sagar, thanks for your comment. With your query, it will delete duplicate data including original data also. But we need only duplicate data to get removed. There are several ways to get the same result. I had showed the one, there are many other simple ways too which can be used.
In mysql when trying to delete the duplicates, Im getting a message that says"table doesn't exist". How are you able to delete from a cte?
Hi, thanks for your comment. Table doesn't exist means there is no existing table. So, first need to create the table with same structure which is used in the session and next we need to execute CTE and next query together to perform the deletion..