Changes between Version 2 and Version 3 of Recette SQL SommeEffectifs


Ignore:
Timestamp:
Feb 14, 2010 10:05:33 PM (15 years ago)
Author:
cedric
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Recette SQL SommeEffectifs

    v2 v3  
    1212{{{ 
    1313select sum(s.lot_effectif),s.annee,s.dev_libelle from( 
    14 select *, extract(month from ope_date_debut) as mois,extract(year from ope_date_debut) as annee from  iav.vue_lot_ope_car  
     14select *, extract(year from ope_date_debut) as annee from  iav.vue_lot_ope_car  
    1515where lot_tax_code='2038' --anguille 
    1616and ope_dic_identifiant=6 --passe à anguille