sql query reg count of column values

• swatianand83

  SSC Eights!

  Points: 930

  More actions

  September 30, 2008 at 10:47 pm

  #194270

  I have a table with 2 columns: AgrNo and RowFlag. RowFlag can have 2 values ie 'Y' or 'N'. I would like to count the number the total 'y' and 'N' for a corresponding AgrNo.

  Resultant set will have 3 columns: Agrno, CountOf(Y) and CountOf(N).

  countOf(Y) : will have the count of RowFlag with value as 'y' for an AgrNo

  countOf(N) : will have the count of RowFlag with value as 'N' for an AgrNo

  any suggestions how to go about it

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  October 1, 2008 at 12:24 am

  #879326

  SELECTagrNo,

  SUM(CASE WHEN rowFlag = 'Y' THEN 1 ELSE 0 END) AS countOfY,

  SUM(CASE WHEN rowFlag = 'N' THEN 1 ELSE 0 END) AS countOfN

  FROMTable1

  GROUP BYagrNo

  ---

  N 56°04'39.16"
  E 12°55'05.25"

• swatianand83

  SSC Eights!

  Points: 930

  More actions

  October 1, 2008 at 3:51 am

  #879373

  the suggestion helped. Thanks a ton.