PDC_REPORT_CreazioneDB/sql/Collaudo/viste/C6MartPeriodico_vNumeroIntermediari.sql
2025-06-10 15:29:00 +02:00

4 lines
201 B
SQL

CREATE VIEW [C6MartPeriodico].[vNumeroIntermediari] AS
SELECT RETE, COD_FISCALE, count(DISTINCT INTERMEDIARIO) as NumeroIntermediari
FROM C6MartPeriodico.PATRIMONIO_TERZI
GROUP BY RETE, COD_FISCALE