How to get Top 10 Salaries from a Table
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 |
Explain about cursor stability?
What is the syntax of SELECT statement when embedded in a COBOL program?
is it possible to get -811 error when you use cursors. why?
How do I import a csv file into db2?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
Can we delete records from view?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
How to compare data between two tables in db2?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What action db2 takes when a program aborts in the middle of a transaction?
What is dbrm?
Is db2 a mainframe database?