MCQs>IT & Programming>Microsoft SQL Server>A production house needs a sale report where total sale of the day is more than $20,000. Which of the following query should be used?
Microsoft SQL Server MCQs
A production house needs a sale report where total sale of the day is more than $20,000. Which of the following query should be used?
Answer
Correct Answer: select count(OrderDate),sum(amount) from orders group by OrderDate having sum(amount) 20000
Explanation:
Note: This Question is unanswered, help us to find answer for this one