for example emp table i am telling hiredate=add

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

Question Posted / revanth reddy

2 Answers
9999 Views
TCS, I also Faced
E-Mail Answers

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

how to test reports in cognos?

1032

What is meant by Reportstudio shortcut?

2190

How do you call a store procedure within a transformation?

1008

What is called Cognos powerplay?

1087

What are the types of catalogs in cognos?

1146

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2283

Explain informatica architecture?

1005

What is Bitmap Index?

1053

Diff b/w Crossproduct and Outerjoin?

2289

All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me

2101

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2767

What is set to be Cognos configuration?

1032

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1913

What are various types of gateways in cognos?

1064

-----------------What is Direct and Conventional loading?

2177