How to get Top 10 Salaries from a Table
Answer Posted / 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 |
Post New Answer View All Answers
Which isolation level provides maximum concurrency?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
List out the data types available.
What are bind parameters in db2?
Is schema the same as database?
Which are the db2 tools to protect integrity of the database?
What is schema in db2?
What happens in bind step in a db2 program?
What is db2 command?
How would you find out the total number of rows in a db2 table?
What is bufferpool in db2?
What is scrollable cursor in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Explain what are the various isolation levels possible?
Comment whether the cursor is closed during commit or not.