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
What is difference between static and dynamic array?
In customizing company code productive means what? What it denotes?
what is publisher?
Name the OSI layer in which we use the bridge?
What is the minimum ram for windows 10?
List the key components of hibernate.
What are some of the movement types for stock transport order?
What are the testing type supported by selenium webdriver?
What is the tag property useful for?
How can custom Hierarchies be created?
Why do we use %rowtype & %type in plsql?
What is open delta Xformer? It's adavntages & Use?
How in different ways patriotism can be shown?
Do we have to use the relative addresses when hosting in the iis or the absolute addresses? Why?
What is a state in react?