Resolved: Joins and Duplicate records
Why is there an error while removing the duplicate records? And how specifically the Group by clause works for removing the duplicates?
Pls view the attached screenshot.
Pls view the attached screenshot.
3 answers ( 1 marked as helpful)
Hi Saurav!
Thanks for reaching out.
You have to disable the
Then, restart Workbench in order to save the new settings.
Group by gathers rows with the same values into single groups. This helps eliminate duplicate rows by showing only one result for each group.
Hope this helps.
Best,
Tsvetelin
Thanks for reaching out.
You have to disable the
ONLY_FULL_GROUP_BY mode in order to resolve the 1055 error message. Please, use the following code:SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); Then, restart Workbench in order to save the new settings.
Group by gathers rows with the same values into single groups. This helps eliminate duplicate rows by showing only one result for each group.
Hope this helps.
Best,
Tsvetelin
Thanks! This worked.
Hi Saurav!
You are very welcome!
Best,
The 365 Team