How to get Top 10 Salaries from a Table
Answers were Sorted based on User's Feedback
Answer / abirami
select max(salary) from tablename
fetch first 10 rows only
Is This Answer Correct ? | 4 Yes | 25 No |
what is datacom db?
how can i pull up a query which was previously stored in qmf
What is the significance of DB2 free space and what parameters control it?
Mention some fields that are a part of sqlca.
What is a data page?
What is scrollable cursor in db2?
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.
What are the advantages of using a PACKAGE?
What is difference between rollback and commit?
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?
What is view db2?
Is db2 relational database?