TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
munir tailor
1.2k
533
14.9k
i want to ignore values contains 0 zero
Feb 1 2020 9:33 AM
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
Reply
Answers (
5
)
How to generate orgpath as column of datatype hierarchyid.
Pivot table or operator