write a query to display to 10 max record from the employee table?

Categories >> Software >> Data Warehouse >> Cognos
Suggest New Category

write a query to display to 10 max record from the employee
table?

Question Posted / sekhar

8 Answers
12901 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query to display to 10 max record from the employee table?..

Answer / sandy

select top 10 * from employee order by salary desc

Is This Answer Correct ?

6 Yes

3 No

write a query to display to 10 max record from the employee table?..

Answer / phoebe

select * from
(
select * from employee
order by salary desc)
where rownum<11;

Is This Answer Correct ?

4 Yes

2 No

write a query to display to 10 max record from the employee table?..

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

write a query to display to 10 max record from the employee table?..

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

write a query to display to 10 max record from the employee table?..

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

write a query to display to 10 max record from the employee table?..

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

write a query to display to 10 max record from the employee table?..

Answer / rajasivam.p

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

write a query to display to 10 max record from the employee table?..

Answer / madhoo

select * from emp a
where (select count(distinct sal) from emp b where
a.sal<b.sal)=&n order by sal desc
/

this is the exact query........when there are duplicate
salaries are there also........

Is This Answer Correct ?

0 Yes

5 No

Post New Answer