Subin Thomas

Subin Thomas

  • 426
  • 4.3k
  • 35.2k

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 (10)