Answer / romeu viegas

Select ...
FROM ...
WHERE ...
FETCH FIRST 1 ROW ONLY

Answer / parthasarathi

select * from
(select * from emp a where rowid<(select max(rowid) from
emp b where a.empno=b.empno) x
where rownum=1

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers   IBM,

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

Is ibm db2 open source?

0 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What is ibm db2 client?

0 Answers  

---

What is collection in db2 bind?

0 Answers  

---

Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.

2 Answers   IBM,

---

Why db2 is called db2?

0 Answers  

---

What is an alias?

3 Answers  

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---