KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a query that counts the price of all items between two dates. Here is the select statement: SELECT SUM(Price) AS TotalPrice FROM Inventory WHERE (DateAdded BETWEEN @StartDate AND @EndDate) You can assume all of the tables have been set up properly. If I do a select between two dates and there are no items within that date range, the function returns NULL as the TotalPrice rather than 0. How can I make sure that if no records are found, 0 gets returned rather than NULL?
Tags (comma-separated)
Save Edits
Cancel