write a query to display the third record from the employee
table?
Answers were Sorted based on User's Feedback
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 |
Answer / srinu
select * from (select rownum r,emp.* from emp) where r=3;
Is This Answer Correct ? | 3 Yes | 1 No |
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 |
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 |
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 |
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 |
Which lifecycle we will use for reporting?
What is the difference between filter & Condition?
Can we test the report other than manual testing?
How many fact tables and dimension tables in your project?
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,,,
How u provide security to reports in report studio or in cognos connection?
write a query to display the third record from the employee table?
How can you create prompts in framework manager?
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
what is Associated grouping? and how it works in cognos impromptu?
how u migrate reports to cognos 8 from previous versions
What junk dimension contains?