How will you delete duplicate records from a table?

7 Answers   Google,

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

What is -904 sql code? How to resolve it?

3 Answers  

---

How to resolve -803 sql code in DB2?

3 Answers   Cap Gemini,

---

What r the comman abends in db2, jcl and cobol???????

0 Answers   Mphasis,

---

---

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 Answers  

---

What is db2 optimizer?

0 Answers  

---

What are the abend codes occour in ur latest PROJECT in DB2

2 Answers   Cap Gemini,

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

---

What are the three DB2 date and time data types and their associated functions?

1 Answers  

---

Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?

6 Answers  

---

How to find the maximum value in a column in the db2 database?

0 Answers  

---