write a query to display to 10 max record from the employee
table?
Answers were Sorted based on User's Feedback
Answer / sandy
select top 10 * from employee order by salary desc
Is This Answer Correct ? | 6 Yes | 3 No |
Answer / phoebe
select * from
(
select * from employee
order by salary desc)
where rownum<11;
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / madhusudhan
select rownum rn,(select e.* from emp e)
order by sal desc
where rn>=&rn;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ram
select * from
(
select e.*,dense_rank() over(order by sal desc) rank from emp e
)
where rank<=&rank
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nasa
select *from emp where sal in(select max(sal) from emp where level<=10 connect by prior sal>sal group by level);
This query show the top 10 records based on the salary
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / narender.v
select * from emp x where &n=(select count(distinct sal)
from emp y where x.sal<=y.sal)
it will prompt for the value give the values as 10 u will
get the output
Is This Answer Correct ? | 2 Yes | 6 No |
To find nth value
select salary from emp a where &n=(select count(distinct
salary) from emp b where a.empno<=b.empno);
to find max by nth value a.empno<=b.empno
to find min by nth value a.empno>=b.empno
OR
To find 10 max records
select * from (select * from emp order by salary desc) where
rownum<=&n;
Is This Answer Correct ? | 0 Yes | 4 No |
How we check the errors before running the report?
--------------what is MemberCaption?
i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..
-------------Diff b/w Union and Unionall?
what are summary filters? grouped filters?
what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me
..Architectural difference between cognos reportnet and cognos8?
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
Why do we create shortcuts in framework manager
what is an associated query?
What is the difference between List and Cross tab? Could some on explain with an example..
What is minimum version of internet explorer to run the Cognos report.