Hello,
i want to remove duplicates from the main table. I found a mini queries sql code in the internet, but they show me the count of the Duplicates.
How can I remove the duplicates and keep only the entry on the top(FirstID).
Tabelle1
Thanks for the help
i want to remove duplicates from the main table. I found a mini queries sql code in the internet, but they show me the count of the Duplicates.
How can I remove the duplicates and keep only the entry on the top(FirstID).
Code:
SELECT First(Tabelle1.Duplikate) AS [Duplikate Feld], Count(Tabelle1.Duplikate) AS AnzahlVonDuplikaten
FROM Tabelle1
GROUP BY Tabelle1.Duplikate;
Tabelle1
Num | Duplicate | Test |
---|---|---|
1 | a | 1 |
2 | b | 2 |
3 | b | 2 |
4 | c | 4 |
5 | c | 5 |
6 | c | 6 |
7 | d | 7 |
8 | d | 8 |
9 | d | 9 |
Thanks for the help