how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

---

What is commit in db2?

0 Answers  

---

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

---

What do you mean by NOT NULL? When will you use it?

3 Answers  

---

What is the max length of sqlca?

0 Answers  

---

---

What is dbrm?

0 Answers  

---

How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,

---

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,

---

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 Answers  

---

how will you retrieve first record in table

1 Answers   UST,

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

---