Suthish Nair

Suthish Nair

  • 43
  • 31.6k
  • 6m

How to get column list having null values

Jun 18 2011 6:44 AM

 How to get column list having null values

 Table1
 =====

 ID  Name  City  Email
 1   N1      e1 
 2   N2  C2
 3  N3  C3  e3


 I need a query to find those columns whose rows having null values.

 Above, o/p will be City and Email

 Don't want to use the conditions like City is null or email is null


Answers (3)