Ejemplo 1: consultar postgres eliminar duplicados
DELETE FROM dups a USING (
SELECT MIN(ctid) as ctid, key
FROM dups
GROUP BY key HAVING COUNT(*) > 1
) b
WHERE a.key = b.key
AND a.ctid <> b.ctid
Ejemplo 2: postgresql elimina filas duplicadas 2 columnas
DELETE FROM sf_table
WHERE id IN
(SELECT id
FROM
(SELECT id,
ROW_NUMBER() OVER( PARTITION BY tosp, icd
ORDER BY id ) AS row_num
FROM sf_table ) t
WHERE t.row_num > 1 );
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)