Answer / m m naidu

To display the 3rd record of emp table we can write query as
select * from emp where rownum<4 minus select * from emp
where rownum<3;

Answer / srinu

select * from (select rownum r,emp.* from emp) where r=3;

Answer / j

select * from emp e where 3=(select count(sal) from emp
where e.sal>sal)

Answer / i.anil

select a.*,rownum from
(select b.*,rownum rk from
(select * from emp )b)a where rk=3;

Answer / vsandhyana

select top 1 * from (select top 3 * from employee order by
employeeid desc) emp

Thanks
Vsandhyana

Answer / ammu

select * from emp e where 4=(select count(sal) from emp
where e.sal>sal)

Because it follows n-1 rule..

How to generate cubes in cognos?

0 Answers  

What is model?

0 Answers  

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

0 Answers   iFlex,

what is boxtype

1 Answers   IBM,

Can you explain a cognos controller?

0 Answers  

how to handle multifact?

2 Answers   IBM,

How can we find out cardinality between two tables?

3 Answers   Dominion,

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 main difference mapplets and mapping?

0 Answers  

After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,

what is Governor settings in cagnos?

5 Answers  

What is the function of cognos dispatcher?

0 Answers