Null Value column names

• Minnu

  SSCertifiable

  Points: 6451

  More actions

  August 12, 2013 at 2:53 am

  #278584

  hi Team,

  Am having a table with 100 columns, and 500 records,

  in that some records values are NULL, i want to find out how many column are there with NULL records.

  i want all NULL value column names.

  eg :

  col1 col2 col3

  a NULL city

  b YOK BHK

  c LOK BTL

  Output

  col2,

  col1, and col3 contains no NULL values, only col2 contains NULL, hence i want col2 as output.

  Please help...

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  August 12, 2013 at 6:31 am

  #1640540

  This thread lists of few possible solutions:

  http://stackoverflow.com/questions/63291/sql-select-columns-with-null-values-only

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP