1 2 3 4 5 6 7 8 9 10 11
| select factm_exploite_par, fact_adm_os, sauvegarde_donnees, secours_inst_sys_remunere, service_dispo, service_admin, sensi_serv, rs.projet_sous_controle, rs.plage_service_pco, rs.dispo_renforcee, rs.taux_dispo_renforcee, co.nom_const, pco.nom_pco, rs.ADMIN_DELEGUEE, count(*)
from REF_SERVEUR rs,REF_MACHINE rm,REF_MODELE mo,REF_CONSTRUCTEUR co,REF_PCO pco
where (rs.pk_machine = rm.pk_machine)
AND (rm.pk_modele = mo.pk_modele)
AND (mo.pk_const = co.pk_const)
AND (rs.pk_nom_pco = pco.pk_pco (+))
AND (rs.statut = 'ACTIF')
AND (infog_classe = 'SERVEUR')
AND (grp_instance_sys = 1 )
group by factm_exploite_par, fact_adm_os, sauvegarde_donnees, secours_inst_sys_remunere, service_dispo, service_admin, sensi_serv, rs.projet_sous_controle, rs.plage_service_pco, rs.dispo_renforcee, rs.taux_dispo_renforcee, co.nom_const, pco.nom_pco, rs.ADMIN_DELEGUEE
HAVING count(*) > 2 |
Partager