Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain about MTD(Month To Date) and YTD(Year To Date) with
one example and where you use this in your project?

Answer Posted / sri

Eg for the MTD report is

select sal from emp where hiredate between
trunc(sysdate,'mm') and sysdate;
same for the ytd,qtd place yy or q respectively

Is This Answer Correct ?    14 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2342


What is the difference between datawarehousing and businessintelligence?

1105


how many reports have u created ? explain a few.

2108


what is the difference b/w the refresh and buffered data?

2347


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2448


What Is The Difference Between Oltp And Olap?

1131


Can we create universe with no cache??

2515


What is thumbnail?

976


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2232


What are the steps to do to use alerts in bo?

1400


what are the tables used in health care domain project and columns used in report?

4515


What are the data types present in bo? What happens if we implement view in the designer and report?

1032


Explain when we use aggregate awareness function in designer?

1033


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4409


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

2007