I have a query below that works to get for me daily count of daily data, but how about if I want to get this query only to give me sums of monthly data ? how the query data looks like ?
select [InsertedDate],count ([InsertedDate]) as EventCount
where [InsertedDate] >='2010-01-01' and [InsertedDate]
group by [InsertedDate]
Order by [InsertedDate] asc
Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.