Interested to Buy Any Domain ? << Click Here >> for more details...
How to get Top 10 Salaries from a Table
- 11 Answers
- 27619 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 |
How to take backup of table in db2?
what is SMP/E? and what are the major steps of it? thanks...
What is the difference between bind and rebind in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
What is the maximum size of varchar data type in db2?
What is the result of open cursor statement?
How can you find out the # of rows updated after an update statement?
What does db2 blu stand for?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
When do you specify the isolation level?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
COBOL 
