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 15385How to convert and use 10mm dia steel 150mm spacing instead of 12mm dia steel which is spacing?
3 29482I 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 7585The customer would like to know about his 15days transactions[like 1st day - 15th day]. how would you do this?
2 6207Post New L&T Interview Questions
What is the function mysql_pconnect() usefull for?
Will system restore delete my files?
What is the difference between an array and Linked list in Machine learning?
Explain salesforce.com security implementation with respect to profiles, roles, and hierarchy, sharing rules, owd(org-wide default settings)? Also, specify which is the most restrictive security setting?
Name the bond linking L chain and H chain?
why can't we call a static method from a non-static method
What does this command do? Cat food 1 > kitty
What is the difference between function and method in c#?
6 what do you like least about testing?
What language is pass by reference?
how do I qualify for the students price of windows 7? What about the oem pricing?
What is skewed distribution & uniform distribution?
which companies in nifty
How to remove duplicates from a list in python ?
How do I know if I have iis on windows server 2016?