SELEZIONA DUPPLICATI

PHOTO

Tue Jan 04 2022 11:37:13 GMT+0000 (Coordinated Universal Time)

SELECT INVOICE_NUMBER, COUNT(INVOICE_NUMBER)
FROM OBT_INVOICES
GROUP BY INVOICE_NUMBER
HAVING COUNT(INVOICE_NUMBER) > 1;

@broulet

CREATE PLSQL JOB SELECT DATI DELLE ULTIME 24H SELEZIONA VALORI DI UNA CERTA DIMENSIONE SELEZIONA DUPPLICATI CREA TABELLA IDENTICA AD UNA ESISTENTE