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 |
Is it possible to apply access manager user rights in impromptu?
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..........
What is called materialized view?
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.....
What is Dynamic Grouping? what is diff between grouping n levelspan?
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 ?
----------How to cretae a Template?
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...
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
------------- How to identify the Revenue Column in Report?
what is cube size?
What is the use of powerplay web viewer in cognos?