Archive for June, 2008
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 )
You are currently browsing the archives for June, 2008
Fusion theme by digitalnature | powered by WordPress
Entries (RSS) and Comments (RSS) ^