main.groupes vue

Colonnes

Définition

CREATE VIEW groupes AS SELECT uid AS groupe_uid, legislature, libelle AS groupe, libelle_abrege AS groupe_abrege, couleur_associee AS couleur, position_politique, vi_mo_de_date_debut AS date_debut, vi_mo_de_date_fin AS date_fin FROM amo30.organe WHERE (code_type = 'GP') QUALIFY (row_number() OVER (PARTITION BY uid ORDER BY _legislature DESC) = 1);

Aperçu