Hassle-free live chat software re-imagined for business growth. 2 users, always free.
select CustomerNo, sum(TotalSales) as TotalSales from dbo.V_Commission_Report where InvoiceDate between dateadd(day, datediff(day, 0 ,getdate())-30, 0) and dateadd(day,datediff(day, 0 ,getdate()), 0) group by CustomerNo
|Oracle 10g - insert string with special characters||8||41|
|How to get sum of group by column and sum of total values||4||55|
|How to load 2 images in same column in Delphi||2||31|
|How can i get data when i use where clause with group by?||3||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!