what is the difference between where clause and having clause

2 Answers   IBM,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

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 role in db2?

0 Answers  

---

Explain about dbrm.

0 Answers  

---

What are packages in db2?

0 Answers  

---

What is buffer pool and list some of them?

0 Answers  

---

what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process

2 Answers  

---

What's the maximum number of volumes that can be added to a STOGROUP?

1 Answers   IBM,

---

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

0 Answers  

---