Explain what is a subquery ?

0 Answers  

---

Differentiate between sga and pga.

0 Answers  

---

What does over partition by mean in sql?

0 Answers  

---

what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  

---

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

What does subquery mean in sql?

0 Answers  

---

What is natural join in sql?

0 Answers  

---

Why partition by is used in sql?

0 Answers  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---