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

Is it possible to apply access manager user rights in impromptu?

1 Answers  


actually my qus is i used some tables in my model,i published that to connection i use that one.at the same way my team member added some new tables and again he published how can i get my model in connection pls pls explain me..........

1 Answers  


What is called materialized view?

0 Answers  


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

0 Answers  


What is Dynamic Grouping? what is diff between grouping n levelspan?

2 Answers   CybAge,


1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?

1 Answers  


----------How to cretae a Template?

4 Answers  


Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...

1 Answers  


How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 Answers  


------------- How to identify the Revenue Column in Report?

0 Answers  


what is cube size?

4 Answers   IBM,


What is the use of powerplay web viewer in cognos?

0 Answers  


Categories