Changes between Initial Version and Version 1 of Recette SQL SommeEffectifs

Timestamp:

Feb 14, 2010 9:43:51 PM (15 years ago)

Author:

cedric

Comment:

--

Recette SQL SommeEffectifs

@@ +1 @@
+{{{
+select sum(s.lot_effectif),s.annee,s.mois from(
+select *, extract(month from ope_date_debut) as mois,extract(year from ope_date_debut) as annee from  iav.vue_lot_ope_car where lot_tax_code='2055'
+) as s
+group by s.annee,s.mois
+order by s.annee,s.mois
+}}}