Answer / s

IN subselect will return rows that match the values in the
IN list. EXISTS will return rows if the subselect return a
true value.

For Read Stability locks are not applicable for phantoms, What is Phantoms?

2 Answers  

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

how to get duplicate records from tables?write qurey for this?

4 Answers   ANZ,

---

How does DB2 store NULL physically?

2 Answers  

---

How to resolve -917 sql code in DB2?

3 Answers   Cap Gemini,

---

What is cloudant database?

0 Answers  

---

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

0 Answers  

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

What do you mean by commit and rollback?

0 Answers  

---

What is lock escalation?

2 Answers  

---

How is the value function used?

0 Answers  

---