Skip to content
Handbok Databaskommunikation
Huvudmoment
Databas
Google Cloud
Big Query
API
Protokoll
Säkerhet
MySQL Workbench
More
Share
Explore
SQL

Delete Duplicates

DELETE FROM MITT_TABELLNAMN

WHERE
id IN (
SELECT
id
FROM (
SELECT
id,
ROW_NUMBER() OVER (
PARTITION BY KOLUMN_NAMNET_SOM_E_DUBLETT
ORDER BY KOLUMN_NAMNET_SOM_E_DUBLETT) AS row_num
FROM
MITT_TABELLNAMN
) t
WHERE row_num > 1
);
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.