Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display the third record from the employee
table?
- 6 Answers
- 10266 Views
- HCL, I also Faced
- E-Mail Answers
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 |
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 ?
Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You
How can I disable the drill-down for the last level of my dimensional hierarchy ????
what is the difference between aggregation and role up aggregation ?
Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:
Why are meta service important then other services?
What is meant by junk dimension?
what is report burn and where it occurs
What are types of batch available in cognos?
where exactly determinants are used in cognos framework manager?
what is the procedure for scheduling conditional rendering?
Explain about scorecarding?
Teradata 
