Skip to content
Advertisement

Duplicate or same record in select query

I tried to execute a select query which I select from the different tables but I still getting duplicate record even I use “DISTINCT”. Below I attached the result from my query.

enter image description here

Advertisement

Answer

DE_Name is different between 2 rows. So it’s correct.

To resolve your problem, just do it

However, the root causes problem is you just need to select some columns that you make sure that it is unique and make sense.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement