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

Question

i have a table in which there are number of fields some fields contain value while some contains 0 value like below table

 

 

abcd	xyz	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