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 are typees of dimensions

11 Answers   HCL,

can we insert all types of charts in a list report? what r the realtime prompts?

0 Answers  

Give me any example of semi and non additive measures?

0 Answers  

What is defined as Cognos Impromptu?

0 Answers  

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 are the components used in web tier?

0 Answers  

What is zero-foot print?

0 Answers  

Explain the workflow of your current project from end to end?what is the steps?

2 Answers   Accenture, Cap Gemini, Cognizant, HCL, IBM, Infosys, Nokia,

What is Additive function?

0 Answers   IBM,

plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?

2 Answers  

What is the difference between the content store and content manager?

0 Answers  

Suppose you have a report with no data , when you run the report in report studio how can you tell the end user , that it has no data , while he runs it?Is it possible ? if so how?

5 Answers   TCS,