-------
SELECT COUNT(*),specialite FROM table GROUP BY specialite
SELECT Table1.Specialite, (select count(*) from table1 as T1 where T1.Specialite = Table1.Specialite ) AS CompteTotal, Count(Table1.Sexe) AS CompteDeFille FROM Table1 GROUP BY Table1.Specialite,Table1.Sexe HAVING (Table1.Sexe="f");
where T1.Specialite = Table1.Specialite
LEFT OUTER JOIN Table1.Specialite ON Table1.Specialite=T.Specialite
RIGHT OUTER JOIN Table1.Specialite ON Table1.Specialite=T.Specialite
SELECT Table1.Specialite, (select count(*) from table1 as T1 where T1.Specialite = Table1.Specialite AND T1.sexe="F") AS CompteDeFille, Count(Table1.Sexe) AS CompteTotal FROM Table1 GROUP BY Table1.Specialite;
18 janv. 2014 à 11:33
24 janv. 2014 à 15:11
where T1.Specialite = Table1.Specialite
par:LEFT OUTER JOIN Table1.Specialite ON Table1.Specialite=T.Specialite
et ca n'a pas marché ya t'il une erreur dans la saisie et je voudrais apprendre votre methode si c'est possible. et merci d'avance.
25 janv. 2014 à 08:48
autant pour moi
Bon conrage !