Forums - C# Corner

Forum guidelines
Subin Thomas

Subin Thomas

  • 547
  • 2.7k
  • 28.5k

how to not show columns having zero records in sql ?

Apr 26 2019 12:10 AM
i have a table having more than 8 columns 
when i search users this 8 column appears some column has zero records in it so i dont want to show the column having zero value,
 
i want to show the clumn having records 
what logic is needed to put in sql to get such output 
 
 if anyone can help,
thanks in advance 

Answers (9)