SQL last day in moth select
- by Saif Khan
I have the following table which is basically the summary of daily transactions and is loaded nightly.
+++++++++++++++++++++++
+ DateCreated + Sale +
+++++++++++++++++++++++
+ 20100101 + 1000 +
+ 20100131 + 2000 +
+ 20100210 + 2000 +
+ 20100331 + 4000 +
+++++++++++++++++++++++
I need to display the sale by month, but only for…