How to achieve this?

• Shriram Chandrasekaran

  Old Hand

  Points: 383

  More actions

  October 18, 2011 at 5:45 am

  #258887

  Hi Guys,

  can anybody tell me the exact query for the following in sql server 2005?

  The following is my table:

  PatIDAgeGender

  132F

  225M

  320F

  418M

  And i need the output like the following:

  Total_Count Persons_above_25No_of_Male whose age>25

  4 2 1

  Thanks & Regards,
  Shriram.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  October 18, 2011 at 5:49 am

  #1395833

  SELECT COUNT(*) AS Total

  , SUM(CASE WHEN Age >= 25 THEN 1 ELSE 0 END) AS CntAge25AndOver

  , SUM(CASE WHEN Sx = 'M' THEN 1 ELSE 0 END) AS CntMales

  FROM dbo.Table

• Shriram Chandrasekaran

  Old Hand

  Points: 383

  More actions

  October 18, 2011 at 6:51 am

  #1395876

  Thank you very much ninja 🙂

  Thanks & Regards,
  Shriram.