I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,

---

How do you find the maximum value in a column in db2?

0 Answers  

---

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

8 Answers   Syntel,

---

When the like statement is used?

0 Answers  

---

What is phantom read in db2?

0 Answers  

---

---

How and when does the db2 enforces the unique key?

0 Answers  

---

what is the difference between join and union?

4 Answers   IBM,

---

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,

---

What is difference between alias and synonym in db2?

0 Answers  

---

what is the sqlcode -501

5 Answers   IBM, Polaris, Zeus,

---

What is temporal table in db2?

0 Answers  

---

What is the difference between static and dynamic SQL?

1 Answers  

---