Having null count greater than 1

• shirish1987

  Right there with Babe

  Points: 776

  More actions

  September 9, 2016 at 12:26 am

  #313210

  Hello,

  I want to display count of records whose null count is greater than 1 group by customer.

  e.g.

  coulumn1 column2

  null 1

  null 1

  123 1

  345 1

  I want to find such records whose null count for coulumn1 is greater than 1 group by column2.

  Please advice on above query.

  Regards

  Shirish phadnis

• Kingston Dhasian

  SSCoach

  Points: 19799

  More actions

  September 9, 2016 at 1:04 am

  #1899957

  Something like this..

  SELECT Column2, SUM( CASE WHEN Column1 IS NULL THEN 1 ELSE 0 END ) AS NullCount

  FROM TableName

  GROUP BY Column2

  HAVING SUM( CASE WHEN Column1 IS NULL THEN 1 ELSE 0 END ) > 1;

  ---

  Kingston Dhasian

  How to post data/code on a forum to get the best help - Jeff Moden
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

• shirish1987

  Right there with Babe

  Points: 776

  More actions

  September 9, 2016 at 1:37 am

  #1899964

  Thanx Kingston.

  It works