29-06-2015, 08:50 AM
وجدت الحل في منتدى اجنبي
كود :
Da.ABSQuery1.Close;
Da.ABSQuery1.SQL.Text := 'Select DISTINCT [color=Red]niveau[/color] , COUNT(*)as tot, COUNT(case when [color=Blue]eleve[/color].[color=Magenta]c_se[/color]=[color=DarkOrchid]1[/color] then 1 end) as male, COUNT(case when eleve.c_se=2 then 1 end) as female from eleve group by niveau ';
Da.ABSQuery1.Open;
