Write a unique difference between a function and a stored procedure.

0 Answers  

---

Is mariadb nosql?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

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,

---

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

---

---

How do you bind variables in pl sql?

0 Answers  

---

Why do we go for stored procedures?

0 Answers  

---

how do you know if your mysql server is alive? : Sql dba

0 Answers  

---

Types of joins ?

11 Answers   Polaris, TCS,

---

Can we insert data in view?

0 Answers  

---

What is number function in sql?

0 Answers  

---

What is a function in oracle pl sql?

0 Answers  

---