How do I partition in sql?

0 Answers  

---

What is difference between left and right outer join?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

---

Why we use join in sql?

0 Answers  

---

What is write ahead logging in sql server?

0 Answers  

---

What are reports usually used for?

0 Answers  

---

Is postgresql a nosql database?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

Store procedure will return a value?

4 Answers   eMids,

---

What does cursor do in sql?

0 Answers  

---