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 |
When is the skeleton cursor table created?
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
Are views updateable?
where can we use index and subscript ? with example ?
How many buffer pools are available in db2?
What is a view? Why use it?
what happend with out using Commit,when closing cursor and program?
what is differnece between DROP TABLE & DELETE TABLE .
What if we fail to give values in columns declared as NOT NULL ?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What do you mean by NOT NULL WITH DEFAULT? When will you use it?