i want to ignore values contains 0 zero

Accepted answer

SELECT foodfee, admissionfee FROM TableName where foodfee not null and admissionfee not null group by foodfee,admissionfee having sum(foodfee)+Sum(admissionfee) > 0 order by foodfee desc;

Salman Beg6y ago

select * from table where foodfee > 0 and admissionfee > 0

Ashutosh Gupta6y ago

SELECT foodfee, admissionfee FROM TableName where foodfee>0 and admissionfee>0

munir tailor6y ago

but 0 0 should not be displayed

Ravi Patel6y ago

Select * from tablename where foodfee>0 or admissionfee>0

food fee	admission fee
100	0
0	100
50	50
0	0