Interested to Buy Any Domain ? << Click Here >> for more details...
How to get Top 10 Salaries from a Table
- 11 Answers
- 28122 Views
- Accenture, HTC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / regu
select distinct salary from table name hwre rownum <=10
| Is This Answer Correct ? | 6 Yes | 5 No |
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 |
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 |
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 |
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 |
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 |
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 |
Answer / samsunisa
select top 10 salary from table name order by salary;
| Is This Answer Correct ? | 7 Yes | 19 No |
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Is db2 a mainframe?
What is performance tuning db2?
What is the syntax for FETCH in DB2 ?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is a result table?
what is Runstats? Whem will u choose to runatats?
What is check constraint in db2?
What is host variable in db2 cobol?
What do you need to do before you do EXPLAIN?
What is a DB2 catalog?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
COBOL 
