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 |
Define catalog in cognos and write its various types?
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
What is Local Cache and how does it help in performance tuning
what is degenerate key in oracle ?whare do we use it?
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?
What actually a project contains?
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
How can we create regular dimensions & measure dimensions?
-------------How you design DWH?
Can we create reports using OLTP database?How?
What is model?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?