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 15464How to convert and use 10mm dia steel 150mm spacing instead of 12mm dia steel which is spacing?
3 29689I 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 7720The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
2 6293Post New L&T Interview Questions
Is fortran still used today?
What is the basic function of paging?
What is the difference between uniformity of content and content uniformity as official test for all tablets?
Explain High Severity and Low Priority with example?
What is a router in react.js?
What's singleton activation mode in .net?
We take the area of collector wide comparison to base and emitter. Why?
What is the advantage of sql server?
When did solar system come into existence? What is the expected life of solar system?
What is a .lib file?
What are the uses of ms excel in our daily life?
What are Trigger events? & context variables?
How many types of autowiring are there in spring?
What is the use of web.config?
How do you select all?