How to get Top 10 Salaries from a Table

Answers were Sorted based on User's Feedback



How to get Top 10 Salaries from a Table..

Answer / meena dogra

The query will be like this:

Select distinct salary from table
order by salary desc
fetch first 10 rows only

Is This Answer Correct ?    31 Yes 5 No

How to get Top 10 Salaries from a Table..

Answer / shammi

SELECT *
FROM (select * from employee ORDER BY salary desc) employee2
WHERE rownum <= 10
ORDER BY rownum;

correct me if am wrong

Is This Answer Correct ?    3 Yes 1 No

How to get Top 10 Salaries from a Table..

Answer / regu

select distinct salary from table name hwre rownum <=10

Is This Answer Correct ?    6 Yes 5 No

How to get Top 10 Salaries from a Table..

Answer / shaikshavali

if u r using PL/SQL

select distinct id from subs_contacts
where rownum<=10
order by id desc

Is This Answer Correct ?    2 Yes 1 No

How to get Top 10 Salaries from a Table..

Answer / rajesh

db2 "Select Sal from table_name order by sal desc fetch
first 10 rows only with ur"
here i defined an isolation level with ur,so don't be confused.

Is This Answer Correct ?    2 Yes 2 No

How to get Top 10 Salaries from a Table..

Answer / sudhakar1.jha@gmail.com

SELECT Data.Amount FROM (
SELECT ROW_NUMBER() OVER(ORDER BY CUR_ANN_AMT DESC) AS RN,
Amount
FROM Employee_table) AS DATA
WHERE DATA.RN BETWEEN 1 AND 10 ;;;;

Is This Answer Correct ?    0 Yes 0 No

How to get Top 10 Salaries from a Table..

Answer / bharath

In Oracle,
select e1.* from emp e1
where &n>(select distinct(COUNT(*)) from emp e2
where e1.sal>e2.sal)order by sal;


Place where n=10
we get,

Is This Answer Correct ?    2 Yes 3 No

How to get Top 10 Salaries from a Table..

Answer / bharath

select sal from(select ename,sal rownum from emp orderby sal
desc group by sal,rownum)where topsal='&nth';

Is This Answer Correct ?    1 Yes 2 No

How to get Top 10 Salaries from a Table..

Answer / abirami

Sorry.. Answer 1 given by me is incorrect.

Correct Query is

select disntinct salary from tablename
Order by salary
Fetch first 10 rows only

Is This Answer Correct ?    9 Yes 13 No

How to get Top 10 Salaries from a Table..

Answer / samsunisa

select top 10 salary from table name order by salary;

Is This Answer Correct ?    7 Yes 19 No

Post New Answer

More DB2 Interview Questions

What is a view? Why use it?

2 Answers  


Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?

2 Answers   L&T, UST,


how to fetch multiple records without using cursor

14 Answers   HCL,


Define data page.

0 Answers  


where can we use index and subscript ? with example ?

3 Answers   CTS,






When the like statement is used?

0 Answers  


what is the Foreign key? explain?

2 Answers  


Explain the use of the WHERE clause.

2 Answers   IBM,


What are db2 objects?

0 Answers  


How does db2 sample database connect?

0 Answers  


What is the size of a data page?

2 Answers   IBM,


Name the lockable units in DB2?

0 Answers  


Categories