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 ;;;;

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1077

---

What is dbrm?

1106

---

What is the connection string to connect to the DB2 Database ?

1128

---

What is check constraint. Explain with example.

1109

---

What is null in db2?

1026

---

What is a system catalog table in db2?

1187

---

How do I copy a table in db2?

1000

---

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1241

---

Discuss about db2 bind?

1098

---

What is host variable in db2 cobol?

1078

---

How to run db2 command in windows?

1193

---

What is the physical storage length of timestamp data type?

1095

---

How can you count the number of rows from a table tab?

1093

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157

---

How to check table size in db2 sap?

1040

---