Which is faster subquery or join?

0 Answers  

---

How do you create a unique index?

0 Answers  

---

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

Explain two easy sql optimizations.

0 Answers  

---

---

Can we rename a column in the output of sql query?

0 Answers  

---

What is before trigger?

0 Answers  

---

What is the difference between microsoft access and sql?

0 Answers  

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

---

What are aggregate functions in sql?

0 Answers  

---

What is sqlite format?

0 Answers  

---