Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
2
Answers
sql query Negative values assign 0 in case using
Thirunavukkarsu j
9y
389
1
Reply
Hi
My sql query is below
SELECT (SUM(CAST(TOTAL_TRIPS_SLUM AS BIGINT)) - SUM(CAST(SLUM_SUPPLY AS BIGINT))) as Balance FROM TBL_SMS_REPORT
WHERE date= '2015-09-01'
Out put is :
-9
i need negative values 0 assign how this write the commant.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Getting same average values excute the stored procedure
stored procedure returns Null value