Problem with getting the count of records when using group by and having

• vijay-367524

  SSC-Addicted

  Points: 481

  More actions

  August 22, 2011 at 10:33 am

  #98387

  Hello All,

  I have the below query returning the result set. I just want to get the total records returned by the query. But iam not able to get the count. Please let me know how can we achieve this. Iam running this query in a function.

  select count(MclId) from vDCRDoctordetails

  where LocationId=121 and month(DcrDate)=4 and year(DcrDate)=2011

  and UserId=121 group by MclId having count(MCLId)=1

  Thanks,

  Vijay

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 22, 2011 at 10:38 am

  #1371559

  SELECT COUNT (*) FROM (

  select MclId from vDCRDoctordetails

  where LocationId=121 and month(DcrDate)=4 and year(DcrDate)=2011

  and UserId=121 group by MclId having count(MCLId)=1

  ) dtGrpBy