1 2 3 4 5 6 7 8 9 10
|
SELECT DATE_VENTILATION,libelle_taux_marque,code_taux_marque , PPH_UG , vente_ppm_sug , vente_remise_ppm_sug , pph_sug , vente_ppm_ug,vente_remise_ppm_ug,
ROW_NUMBER() OVER(PARTITION BY DATE_VENTILATION,libelle_taux_marque,code_taux_marque , pph_sug , vente_ppm_sug , vente_remise_ppm_sug , pph_sug , vente_ppm_ug,vente_remise_ppm_ug
ORDER BY DATE_VENTILATION,libelle_taux_marque,code_taux_marque , pph_sug , vente_ppm_sug , vente_remise_ppm_sug , pph_sug , vente_ppm_ug,vente_remise_ppm_ug ) AS duplicate_count
FROM VENTILATION_VENTE_TXMARQUE
where DATE_VENTILATION between '10/10/2012' and '10/10/2012'
)
delete
FROM list_duplicates
WHERE duplicate_count > 1 |
Partager