for exmaple:- food fee admission fee 100 0 0 100 50 50 0 0 now i want query which ignore 0(zero) values in both fees fields.so output should be 100 0 0 100 50 50

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;

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

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

but 0 0 should not be displayed

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

Answers

i want to ignore values contains 0 zero

munir tailor

715

for exmaple:-

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

now i want query which ignore 0(zero) values in both fees fields.so output should be

100 0

0 100

50 50

Answers (5)

Next Recommended Forum

How to generate orgpath as column of datatype hierarchyid.

Pivot table or operator

Leaderboard

View all

Netaji Junghari

+79

George

Lokendra Singh

-1

View all

Yesterday's leader

Netaji Junghari

Bangalore (India)

897

103.7k

852

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

711

9.7k

1.3k

Speaker of the month

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

156

117.7k

11.8k

500

Upcoming events

View all

Suggested for you

View all

Bhawesh Deepak

Ashish Shukla

Dharmeshwaran S

Jithu Thomas

Bala S

Forum Statistics

Please welcome our newest member Nimblesite Pty Ltd.
3,078,320 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 6 new threads, 25 new posts, and 68 new users.
In last week, the most popular thread is 'Get 24 months rollover value from database'.