What is the usage of the distinct keyword?

0 Answers  

---

What is the max nvarchar size?

0 Answers  

---

What is rank dense_rank and partition in sql?

0 Answers  

---

What are aggregate and scalar functions?

0 Answers  

---

Which one is better subquery or joins?

0 Answers  

---

---

Is it possible to update views?

0 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

What is indexing oracle sql?

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

What are two virtual tables available during database trigger execution ?

2 Answers  

---

How do I view stored procedures?

0 Answers  

---