dont want records which has 0 amount in it in sql !

Question

i have fetched records with 3  tables joined i got 42 row of it it has a column name amount which is year wise so it contains 0 amount  as well as some amount eg 20045,43550 etc

so i want to add a case or something so that i can get only amount which is greater then 0

 

i think i will have to write a case for that in query but im not sure of it so need help on the same

 

thanks 

subin.