What is the execution plan in sql?

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

What are all types of user defined functions?

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

---

How can you select unique records from a table?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

What does count (*) do in sql?

0 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

How do we accept inputs from user during runtime?

0 Answers  

---

Which is better trigger or stored procedure?

0 Answers  

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

---