My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

What is db2 connect?

0 Answers  

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

List down the types of triggers in the db2 database?

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  

---

---

Are views updatable ?

4 Answers  

---

How to execute stored procedure in db2 command editor?

0 Answers  

---

How many clustering indexes can be defined for a table?

2 Answers  

---

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  

---

What information is held in SYSIBM.SYSCOPY?

1 Answers  

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

What are leaf pages?

3 Answers  

---