Answer / Akshay Vivek

"The main difference between LEFT OUTER JOIN and RIGHT OUTER JOIN is the ordering of tables. A LEFT OUTER JOIN returns all records from the left table and matched records from the right, if any. A RIGHT OUTER JOIN does the opposite: it returns all records from the right table and matched records from the left."

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

Can triggers stop a dml statement from executing on a table?

1 Answers  

---

Is it possible to sort a column using a column alias?

1 Answers  

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

explain advantages of myisam over innodb? : Sql dba

1 Answers  

---

Is left join same as join?

1 Answers  

---

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

1 Answers   Pitney Bowes,

---

Why do you partition data?

1 Answers  

---

what is the difference between granting and creating a view?

2 Answers  

---

what are sequences

1 Answers  

---

What is the use of partition by in sql?

1 Answers  

---

Is nosql relational?

1 Answers  

---