Posts Tagged SQL
Finn duplikater i en tabell
Denne er grei når man skal finne dupliserte verdier i en tabell:
SELECT felt,
COUNT(felt) AS duplikater
FROM tabell
GROUP BY felt
HAVING ( COUNT(felt) > 1 )
Denne er grei når man skal finne dupliserte verdier i en tabell:
SELECT felt,
COUNT(felt) AS duplikater
FROM tabell
GROUP BY felt
HAVING ( COUNT(felt) > 1 )
Fusion theme by digitalnature | powered by WordPress
Entries (RSS) and Comments (RSS) ^