Forum » Pomoč in nasveti » help - duplicate values and primary key
help - duplicate values and primary key
Thorvald ::
pozdrav
združiti hočem dve tabeli (ne join ampak import) pa pride do problema ker PK ni bil narejen pred vnosom podatkov.
A ima kdo idejo kako v tabeli s približno 10 na 6 rekordov najdem podvojenega.
združiti hočem dve tabeli (ne join ampak import) pa pride do problema ker PK ni bil narejen pred vnosom podatkov.
A ima kdo idejo kako v tabeli s približno 10 na 6 rekordov najdem podvojenega.
Thorvald ::
če koga zanima:
select distinct *
FROM Tabela
WHERE (Index1 IN (SELECT [Index1]
FROM [Tabela] AS Tmp
GROUP BY [Index1], [Index2], [Index3], [Index4], [Index5]
HAVING COUNT(*) > 1 AND [Index2] =[Tabela].Index2]
AND [Index3] = [Tabela].[Index3]
AND [Index4] = [Tabela].[Index4] AND [Index5] = [Tabela].[Index5]))
ORDER BY Index1, Index2, Index3, Index4, Index5
select distinct *
FROM Tabela
WHERE (Index1 IN (SELECT [Index1]
FROM [Tabela] AS Tmp
GROUP BY [Index1], [Index2], [Index3], [Index4], [Index5]
HAVING COUNT(*) > 1 AND [Index2] =[Tabela].Index2]
AND [Index3] = [Tabela].[Index3]
AND [Index4] = [Tabela].[Index4] AND [Index5] = [Tabela].[Index5]))
ORDER BY Index1, Index2, Index3, Index4, Index5
Vredno ogleda ...
| Tema | Ogledi | Zadnje sporočilo | |
|---|---|---|---|
| Tema | Ogledi | Zadnje sporočilo | |
| » | Game of Thrones: A Telltale Games SeriesOddelek: Igre | 10206 (7348) | oo7 |
| » | iz dhcp v fiksni ipOddelek: Omrežja in internet | 1906 (1614) | Good Guy |
| » | Kako najenostavneje pridobiti IP iz windowsa 7?Oddelek: Operacijski sistemi | 2499 (2223) | Pesimist |
| » | SQL indeks?Oddelek: Programiranje | 1014 (1014) | ta_pravi |
| » | firefox, thunderbird in zvok v kubuntuOddelek: Operacijski sistemi | 1327 (1086) | comp007 |