Subin Thomas

Subin Thomas

  • 464
  • 4.8k
  • 82.4k

how to show only records having value >0 in sql ?

Mar 27 2019 11:59 PM
i have a table in which there are number of fields some fields contain value while some contains 0 value like below table
 
 
 abcdxyz pqr abc rst
 23 0 5453 54645 0
 45353 0 5456 5646 0
 213 0 45 564 0
 23 0 546 56 0
 
 from above table all the fields having zero should not be visible
only 3 fiels should be visible that is abcd, pqr and abc 
 

Answers (3)