Forum Discussion
data duplicate
Help please
im following alex the analyst on youtube for free tutorial on sql. im using microsoft sql server management studio.
can you help me understand why the first values on top are duplicating?
Hello eloisa18
Definitively you have these duplicates in the source table so you have to find out the reason.
Of course you can use SELECT DISTINCT just to get rid of the dups in the result set , but you have to DELETE the duplicates manually
Regards
Javier
can you help me understand why the first values on top are duplicating?
eloisa18 you query data from one tabel, so the cause is: The data is in the table this way.
- I agree this is a simple table select statement so you have probably made a mistake in a previous step when you populated the table.
If the query was more complex and had joins, other reasons may exist. That is not the case here it is simply that there are duplicates in the table.
