write a query to display the third record from the employee
table?

Answers were Sorted based on User's Feedback



write a query to display the third record from the employee table?..

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;

Is This Answer Correct ?    6 Yes 1 No

write a query to display the third record from the employee table?..

Answer / srinu

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

Is This Answer Correct ?    3 Yes 1 No

write a query to display the third record from the employee table?..

Answer / j

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

Is This Answer Correct ?    3 Yes 2 No

write a query to display the third record from the employee table?..

Answer / i.anil

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

Is This Answer Correct ?    1 Yes 0 No

write a query to display the third record from the employee table?..

Answer / vsandhyana

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

Thanks
Vsandhyana

Is This Answer Correct ?    0 Yes 0 No

write a query to display the third record from the employee table?..

Answer / ammu

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

Because it follows n-1 rule..

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

Which lifecycle we will use for reporting?

0 Answers  


What is the difference between filter & Condition?

3 Answers   MetLife, TCS,


Can we test the report other than manual testing?

0 Answers  


How many fact tables and dimension tables in your project?

3 Answers   IBM,


If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,

0 Answers  






How u provide security to reports in report studio or in cognos connection?

1 Answers   Cap Gemini,


write a query to display the third record from the employee table?

6 Answers   HCL,


How can you create prompts in framework manager?

4 Answers   Tech Mahindra,


I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?

2 Answers  


what is Associated grouping? and how it works in cognos impromptu?

1 Answers   IBM,


how u migrate reports to cognos 8 from previous versions

3 Answers   TCS,


What junk dimension contains?

0 Answers  


Categories