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...

15. If I select the current month and year how can we
display previous 11 months data?

Answer Posted / revanth reddy

for example emp table i am telling
hiredate=add_months(sysdate,-11) from emp

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the roles defined by cognos platform?

1196


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

1018


What is called materialized view?

1134


What are the themes in a data warehouse?

1095


What are the methods by which it non-durable model could be changed into the durable model?

1008


What is defined as Query studio?

1173


What are all the different types of prompt in cognos?

1099


how to connect datamarts

2846


Diff b/w Crossproduct and Outerjoin?

2334


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

2061


What is a Cube?

1184


What do you mean by drill across?

1202


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

1070


what is degenerate key in oracle ?whare do we use it?

2611


What is Metrics designer?

1081