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
What is copy pending status in db2?
What is db2?
How do you select a row using indexes in db2?
Is db2 free?
What's The Error Code For Unique Index Voilation?
What language is db2 written in?
Which component is responsible for processing sql statements and selecting access paths?
What is rct?
What is the difference between drop table and delete table?
Which isolation level provides highest data integrity?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is db2 stogroup?
What is dbrm? When it will be created?
Discuss about db2 bind?
What is db2 bind?