I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
1 15538How to convert and use 10mm dia steel 150mm spacing instead of 12mm dia steel which is spacing?
3 29824I have 5 different country names and their currencies like India-Rupee, USA-Dollar etc. when I run the report, the report should display only either currencies or country names.How to run the report?
3 7842The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
2 6380Post New L&T Interview Questions
What is the functionality of md5 function in php?
Can we run php on tomcat server?
Give reasons supporting that string is immutable.
What is a state in react?
Draw the timing diagram for a SRAM Read. What happens if we delay the enabling of Clock signal?
Mention the different types of triggers?
Find the area of the disc at 62 C whose diameter is 3?
How does @transactional work in spring?
If Debentures Are Issued at Par and Redeemable at Par What Journal Entry Should Be Passed?
What is route model binding?
What is local and formal parameter?
Where is the xml tag in indesign?
What font is most similar to times new roman?
My system suddenly get off,when i try to power on then it does not work but when i open it and clean RAM and insert it again, it power on.but after some day same problem? please give the answer (i have also changed RAM it's new.)
How would you open a file in read-only mode using the vim editor?