What is a SELECT statement?

1 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

---

I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..

5 Answers   CTS,

---

what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,

---

What is page size in db2?

0 Answers  

---

What can the SET option of the Repair Utility accomplish?

1 Answers  

---

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

---