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 / abirami

select max(salary) from tablename
fetch first 10 rows only

Is This Answer Correct ?    4 Yes 25 No

Post New Answer

More DB2 Interview Questions

what is datacom db?

2 Answers   CSC,


how can i pull up a query which was previously stored in qmf

3 Answers  


What is the significance of DB2 free space and what parameters control it?

1 Answers  


Mention some fields that are a part of sqlca.

0 Answers  


What is a data page?

1 Answers  






What is scrollable cursor in db2?

0 Answers  


a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.

3 Answers  


What are the advantages of using a PACKAGE?

2 Answers  


What is difference between rollback and commit?

0 Answers  


Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?

2 Answers   Deloitte,


What is view db2?

0 Answers  


Is db2 relational database?

0 Answers  


Categories