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)

CTE Query(common-table-expressions)