wiki:Recette SQL Bilanjournlier

Version 2 (modified by cedric, 14 years ago) (diff)

--

SELECT count(*),bjo_dis_identifiant, bjo_annee,bjo_tax_code, bjo_std_code 
FROM iav.t_bilanmigrationjournalier_bjo 
group by bjo_annee, 
bjo_dis_identifiant, bjo_tax_code, bjo_std_code
order by bjo_tax_code,bjo_std_code,bjo_annee