How do we use distinct statement? What is its use?

0 Answers  

---

how to retrieve only duplicate values in a table

9 Answers  

---

Please let me know if UNION ALL and Natural Join does the same operation and are same...

7 Answers   iGate,

---

What are the different sql languages?

0 Answers  

---

What is a crud api?

0 Answers  

---

What is a self join ?

6 Answers   BirlaSoft,

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

How does postgresql compare to mysql?

0 Answers  

---

What is execute immediate?

0 Answers  

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---