Answer / lakshmi reddy

select * from(select emp.*,rownum r from emp) where r=5 or r=10

Answer / kart

select * from (select rownum as rn,aone.* from aone)
where rn in(5,10);

Answer / gautam ramteke

select *
from(select rt.*,rownum r from (select * from gpr_employee
order by hire_date)rt)
where r in (5,8);

Answer / gopal

By using rank or dense_rankl()

Answer / harish

select * from emp where rownum<=&n;
if u give 5 insted of 'n' we get 5th record...

What is the difference between static and dynamic conditions?

0 Answers  

How to select all in value prompt instead of cascade prompt?

3 Answers   IBM,

----------------------Diff b/w MOLAP and ROLAP?

4 Answers   Bank Of America,

What are the procedures (or) methods using in Migration process in cognos? I.e. the created report is in development server that moves into production server (client server). Shall we drag or copy the file moving from development to production? It is possible or could you tell me that how will we do it?

1 Answers  

what do you mean by parallel execution of query?

1 Answers   Mind Tree,

What is the size of database for you project?

0 Answers   Accenture,

I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh

2 Answers  

what is requery in cognos?

0 Answers   HMN, Satyam, TCS,

1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?

1 Answers   CTS,

What is the difference between Standard and Metrics folder?

0 Answers  

What is the size of the cube?

0 Answers  

What is the difference between group and associare?

0 Answers