Home Forums Reporting Services Reporting Services SSRS - Count of Distinct People Where Gender = RE: SSRS - Count of Distinct People Where Gender =

  • December 10, 2008 at 12:14 am

    #910096

    Or another one :

    SELECT Sex, COUNT(*) as Total FROM (SELECT Id, Sex FROM dbo.Table GROUP BY Id, Sex) dtName GROUP By Sex

    --ORDER BY Total DESC